HELP! Form Issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Debbie - 29 May 2008 21:01 GMT

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?

Reply to this Message

John W. Vinson - 30 May 2008 23:57 GMT

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

Signature

John W. Vinson [MVP]

Reply to this Message