HELP! Form Issue

[Debbie]

I am trying to use a form. In my table I have a lookup value for
Physician Name. It works fine in the table. In the form it will not
let me change the record. It defaults to the first name in the
physicians table. What am I doing wrong?

 

[John W. Vinson]

I am trying to use a form. In my table I have a lookup value for
Physician Name. It works fine in the table. In the form it will not
let me change the record. It defaults to the first name in the
physicians table. What am I doing wrong?

I don't know, because I don't know what you're doing.

Lookup Fields in tables can be a real hassle. See
http://www.mvps.org/access/lookupfields.htm for a critique.

On the Form, what are the following properties? Open the form in design view;
select Properties from the View menu item, if the properties window isn't
shown:

- The Form's Recordsource property (post the SQL view if it's a query)
- The Physician Name control's Control Source
- the Physican Name control's Row Source (post the SQL)
- The Physician Name control's Default Value (if any)