Question Lookup

[saqibawr]

How to create a form that if i enter product id rest of the product detail comes on that form automatically.

For example i have a database of books & if i enter book id by using combo box rest of its detail, Book Tittle, Author Name, and its price comes on to the form automatically in other field boxes that are created for those fields. If a book id is ISBN1001 and i enter it in the book id field then rest of the fields that are created on form filled automatically.

 

[NigelShaw]

Hi,

why dont you create the form based on your table or query then add a combo box using the wizard? this will give you he option to "find a record on the form" where you can then select the ProductID and the details will be shown on the form. you can also type in the combo box which will find the record if it is there.

NS