Jeremy,
If I put this statement in to limit the records in my recordset:
Dim rst As DAO.Recordset
Set db = CurrentDb()
Set rst = db.OpenRecordset("select * from Master where not isnull(Sentmonths)")
... Which event(s) do put it in if I want to read this recordset when the...
I would like to scroll through the RecordSetClone of my form then only display certain records depending on a condition when the navigation button is pressed. (Previous, next, etc.)
Using vba code, how can I tell what button was clicked on then choose the records to display?
I am using Access...
Hi,
I would try to use "Me.Refresh" in your code so that the main screen is refreshed with the new data from your combo box each time you go to a new record.
Also, I recommend using this help site: allexperts.com I got an answer to a problem pretty darn quick! Hope this helps.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.