HELP! Form Issue

  • Thread starter Thread starter Debbie
  • Start date Start date
D

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?
 
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?
Click to expand...

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)
 
Back
Top