Recent content by mojo67

Thanks for that advice. That did the trick. I now have a new problem. I want the combobox list to be in alphabetical order, so I went to the properties sheet for the combobox and clicked on the ... for the Row Source to build a query. I selected the table, the flight number as the field to...

there is only one table called Flights2

I do not have the actual form , but the example he gave me is this. There is a table containing data in 4 fields Flight Number, From, To and Via. The form will have 4 text boxes. 1 each for Flight Number, From, To and Via. He wants to be able to have the boxes to start off blank, then when a...

Thanks for the quick reply, but could you expand on that please. How do I use dlookup. Also, how do I get the form to open up with the boxes blank Thanks

My brother-in-law has asked me to help with this problem. He has an Access database from which he wants to be able to have a form where the fields are blank until he enters a number in the first field, and then the remaining fields would automatically be filled in with the data in the database...