Search results for query: *

I have yet to sort this one out. I, too, have been tied up with other matters the last several days. I was looking at a related database belonging to another inidividual and I noted that this same problem arose with this individual's database system. Any guidance would be appreciated.

On 10/15/02 I asked a question about DLookup as I was having problems using this function. In responding to my question Paul Bricker explained how to use a combo box query for the purpose of populating form controls based upon related tables. You may find this to be useful as well.

Patient Table includes PatientID, PatientLastName,PatientFirstName,SurgeonID. SurgeonTable includes SurgeonID, SurgeonLastName, SurgeonFirstName, Address, SurgeonULI. (My model for this approach was based upon the Northwinds example included in Access 2002) There is a one-to-many relationship...

Thanks Paul. This is indeed the solution I was looking for on the first matter. I continue to suffer from the latter problem. The form data now inputs appropriately. As I make my entries on the form, the Surgeon table is also updated with a new sequential SurgeonID and a numeric entry (e.g...

I am new to VB coding and am having two problems with DLookup function which I am unable to solve. I have two tables, Patient and Surgeons, linked by SurgeonID. On a Patients form I have a combo box which populates the surgeons last name. I am trying to populate text boxes for a surgeon...