Filtering a Form

[kdbailey]

I'm pretty experienced with using recordsets, but I have yet to really dive into how to filter forms that are set to a recordsource.



I've set my form equal to a table titled "Dealer Table" and I've set all of the other fields to their appropriate fields. There's a few items I need addressing...

1) The user will enter a number into the "Dealer Number" field, which triggers the filter, bringing up all of the other information (address, city, state... etc.) How do I go about filtering the form to bring up the one record belonging to that dealer?

2) Before a number is identified, I don't want any fields to be showing, how do I prevent the first record on the table from showing?

3) If any information needs to be adjusted, I want it set to be able to do so, and I can see that it allows for editing on the table, but the only way I can get it to save the record is by changing to another record. Is there a command to "save" or "update" the current record?

[ranman256]

1. you have a continuous form showing all records, with an unbound text box for dealer#
user enters the # presses enter, in the txtDealer afterupdate event , you filter the records...

private txtDealer_Afterupdate()
if isNull(txtDealer) then
   me.filterOn = false
else
   me.filter = "[field]='" & ctxtDealer "'"
   me.filterOn = true
endif

2. you WANT all records, then filter on them when user fills in box

3. the data is LIVE, you can edit it once it filters.

[kdbailey]

I used the code, it is still showing info for the first record when there is nothing entered into txtdealerno. Is it possible to not show any record if no dealer number is specified? Or do I have to change the control sources through vba?

What I was looking for was the command "docmd.RunCommand acCmdSaveRecord".