Split form update

[rowbro]

Hi all,

I have a simple split form with two input boxes for a starting and finishing date range. Below it a query that utilizes the aforementioned dates. The input boxes work fine (when I open the query separately) and the query works fine, however the query on the split form doesn't update when the dates are updated. Can anyone advice as to how to make this happen?

Thanks,

 

[Micron]

When a form based on a recordsource such as a query or table opens, it gets the data. If you are running a query again afterwards, the form has to be updated. Use whatever code you are running to execute the query to "requery" the form (Me.Requery). I don't suppose it matters if your date inputs are really input boxes or are text boxes on a form, but I've assumed the former, not the latter.

 

[rowbro]

Thanks. Worked great!

 

[Micron]

Glad I could help.