If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HELP! Form Issue
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? |
#2
|
|||
|
|||
HELP! Form Issue
On Thu, 29 May 2008 13:01:56 -0700 (PDT), Debbie
wrote: 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) -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|