New User Needs Help Badly

[Hank Laskin]

Access 2003
I setup a form called Restaurant reservations. Originally, it was setup as
two parts. First part was a database for names of restaurants. The other
was called Reservations.

It worked OK. I then decided to make it one form and incorporated the
reservations with the restaurant reservations.

After doing that, the reservations portions now shows
#NAME? in each blank field that I would normally fill in while making a
reservation.

How can I correct this? Please remember I am new at Access and if you could
give me detailed instructions I would really appreciate it.

 

[phleduc]

#NAME means that field is not recognized, it is no longer part of he
reocrdsource of your form

 

[John W. Vinson]

Access 2003
I setup a form called Restaurant reservations. Originally, it was setup as
two parts. First part was a database for names of restaurants. The other
was called Reservations.

It worked OK. I then decided to make it one form and incorporated the
reservations with the restaurant reservations.

After doing that, the reservations portions now shows
#NAME? in each blank field that I would normally fill in while making a
reservation.

How can I correct this? Please remember I am new at Access and if you could
give me detailed instructions I would really appreciate it.

I think you need to make the Reservations form a Subform of the restaurants
form, using the unique primary key of the restaurants table as the
master/child link field. Of course nobody here can see your computer nor do we
know how the tables are related (if at all), or how you build your forms.

If you're focusing first on the forms... don't. The Tables are where the data
is stored, and they are fundamental! Get your table relationships right first,
and *then* work on the forms.

John W. Vinson [MVP]