I am not a fan of using Wizards, so I find it best to design a form from scratch.
1. make a new form, go into the Design View
2. display the form Header/Footer
from the menu --> View, Form Header/Footer
3. turn on the Properties window
from the menu --> View, Properties
4. choose a RecordSource for the form
if the Properties titlebar does not say "Form", then select the form by clicking in the upper left corner where the rulers intersect
click on the Data tab of the properties window
click in the RecordSource property, drop the list, and pick something. Personally, I base forms directly on tables. This may not be a good idea for huge databases lots of users and back-ends on Oracle, Sybase, etc, but for DBs on PC's, I find that it works just fine.
5. turn on the Fieldlist display
from the menu --> View, Field List
Then, drag fields from the list to the form
As you move the control, the label moves too.
to just move ONE control, drag it by the big box in the upper left corner, when the mouse pointer becomes a pointing finger.
I usually use the Property sheet to size controls (Width, Height) after I have dragged them because I like to pick easy-to-work with numbers.
In the form header, in addition to a title, I put one or more unbound comboboxes to find records.
I like to make a private function behind the form and have several lookups -- or one lookup and change the lookup SQL based on an option group selection so the user has more than one way to find the record -- in any case, the bound column is always a hidden ID, so it can use the same code (I am posting a simple version of my FindRecord code)
AfterUpdate --> =FindRecord()
(you can also use the BeforeUpdate event)
Private Function FindRecord()
'thanks for ideas, freakazeud
If IsNull(Me.ActiveControl) Then Exit Function
'save current record if changes were made
If me.dirty then me.dirty = false
Dim mRecordID As Long
mRecordID = Me.ActiveControl
Me.ActiveControl = Null
Me.RecordsetClone.FindFirst "IDfield = " & mRecordID
If Not Me.RecordsetClone.NoMatch Then
Me.Bookmark = Me.RecordsetClone.Bookmark
as for tutorials, here is one... I haven't read it in detail, but it seems pretty good; you can do a search for morehttp://www.softlookup.com/tutorial/access/ch06.asp
Did you study the sample form I pointed you to on 3/22? Did you do the Steps to Document a Database on it?