Requery doesn’t do it (Access97)

Topic

New Reply

My lstbox reflects Date from Query. I check data Date against it and upload data if greater then in lstbox.
I close form and when open again I can see that Date in listbox even query result is Null
I wrote
Private Sub Form_Load()
Me!lst_Check_Dates.Requery

and it doesn’t do anyhting

I need lstbox to open up empty when query has no result

Thanks

Reply | Quote

Replies

Sorry, but that doesn’t seem to make sense. If the listbox is based on a query, then it sounds like it SHOULD show the dates in the query. A description isn’t enough, we need to see at least the SQL for the query and preferably a database with the form and query in it.

Reply | Quote

Thanks, nevermind, I got it up and running.
thanks

Reply | Quote