i firmly believe you can do it, too, so let's get started.
let's back up a bit and start with the members table. you list your fields
as
Fname
Lname
Address
Phone
okay, except for "Address". any address has several components, which each
belong in their own field - following normalization rules which call for
"atomic" data in each field. recommend you substitute the following for
Address:
Street1
Street2
City
State (include this field even if all your members are currently in the same
state)
Zip
Country (include this field only if appropriate to your needs)
btw, make sure that the PhoneNumber field is a Text data type, not a Number
data type. also recommend you have a tblStates listing each state
abbreviation and full name, as
tblStates
StateCode (AK, AL, AZ, etc, one code per record.) (primary key)
StateName
and further recommend a tblCities, as
tblCities
CityID (autonumber, primary key)
CityName
having city and state tables will cut down on data entry time, and help
prevent typos in those two fields in tblMembers, at least - and every little
bit helps.
now, you need a form for data entry. create a form, and set its'
RecordSource property to tblMembers. add controls for the table fields you
want to see in the form; use a combobox control for the City field, and set
its' RowSource to tblCities; ditto that for the State field, tblStates. if
most or all of your members are currently in the same state, you can set the
DefaultValue of the state combobox to that state code, to save data entry
keystrokes. ditto that for the city combobox.
name the form, frmMembers, and save and close it. now copy it (Ctrl+c, then
Ctrl+v). name the copy frmMembersReview. open frmMembersReview in Design
view, and add the command buttons i described in my previous post, add the
code i posted, and replace the name "Form10" in that code with the name
"frmMembers". save and close.
open frmMembers in Design view, in the form's BeforeUpdate event, add the
code i posted previously, replacing the DoCmd.OpenForms lines with the
following, as
DoCmd.OpenForm "Form10A", , , _
"Fname = '" & Me!Fname & "' And " _
"Lname = '" & Me!Lname & "' And " _
"Address1 = '" & Me!Address1 & "' And " _
"Address2 = '" & Me!Address2 & "' And " _
"City = " & Me!City & " And " _
"State = '" & Me!State & "' And " _
"Phone = '" & Me!Phone & "'" _
, acFormReadOnly, acDialog
read up on the OpenForm action in VBA Help, so you understand how the
arguments work. the above WHERE clause looks for exact matches only in all
those fields. if you want more "fuzzy" matching, employ the use of wildcards
and the Like operator in place of the "=" sign. read up on wild cards in
Access Help so you'll understand how to use them.
hth