Want BLANK form, then populate text boxes from combo box

[JJG]

I am putting together an inventory check out system and cannot get my return form to work right. It pulls its data from a query that is based on a transaction table that contains an EquipmentID, User ID, Out date, and In date. I set up a combo box so that any checked out items will appear in the list. When I choose the item being returned, the user id and check out date appear on my form. The problem is how can I get the form to be blank upon opening. Right now, it contains the first record info from the query until a choose something from the combo box.

This is probably easy but I haven't been using Access long.

Thanks.

 

[Tanis]

In the properties of the form, change Data Entry from No to Yes


David

 

[JJG]

That doesn't work. I think it may be because the form is based on a query. The combo box is set to look up values in the query. It works fine but the form opens with data in it (the first record in the query). I want it to be blank until something is chosen ftom the combo box.

 

[Russell Hauf]

Here's one way that should work:

In the combobox, if you have anything in the Control Source property, delete it. Then base the combobox on a query (Select EquipID from My Table, for example). Then put the following code in the AfterUpdate event of the combobox:

<pre>Private Sub cboMyCombo_AfterUpdate()
Me.Filter = "[EquipID] = " & Me.cboMyCombo
Me.FilterOn = True
End Sub</pre>

Hope this helps,

Russell