Query Results

[FoxStudent]

I want to on selecting a value froma combo fill in several textboxes. For example, if I selecft a phone number I want to fill in a name text box etc. I have wrote a query that I know works to find the correct name for the phone number selected in he combo I just do not know how to put the result into a text box.
Thank u

 

[pjm]

FoxStudent,

You need to set the data source of your text boxes to something like:

=dlookup("[Name]","[tableName]","[PhoneNo]=[forms]![formName]!comboPhone.value&quot

Then you'll need to requery your text boxes in the on change event of the combo.

HTH
pjm

 

[JoeMiller]

In the AfterUpdate event of the combo box you can place code to fill them in like this:

MyTextBox = DLookup("[Customer]","MyQuery","[PhoneNbr]=[cboPhoneNbr]&quot

That's one way to do it. Another is if you put the customer data in the drop down, IE; you have the Customer, Address, etc.. showing when you select the dropdown. You can set the textboxes equal to the column in the combo containing the appropriate data by using the AfterUpdate event.

MyTextBox = cboPhoneNbr.Column(1)

HTH

Joe Miller
joe.miller@flotech.net