MS Access text box

[John Ridley]

Hello Every one!
I am new to MS Access please help me.
I have a linked table with SQL Server I have Created a Forms based on the table.I have a query that need to feed the 2 text box on the form.Its a ID and PID. PID need to populate when user type in the ID in the textbox.I can not have combo box or list box because i have over three thousand record.
I would like when user type in ID(text box)If the record not exists then it shroud through an error ID not found.Please help me and thank you so much!

[zmbd]

The DLookup() function sounds like what you are interested in.

BTW: If you use a query as the recordsource for your combo/listbox the number of records doesn't matter... it may take a while for the control to update.

Please take a look at the artcles dealing with filtering. They may give you an alternative to what you are trying to do.
Microsoft Access / VBA Insights Sitemap
42.Cascaded Form Filtering
55.Multiple Combobox Filter with Clear Option
168.Example Filtering on a Form.

[John Ridley]

Thank you so much for Responding zmbd. I got it.