GotFocus() Requery question (1 Viewer)

[eibyer_apc]

I created a landing form with `="Date: " & Date()` field that I would like to update automatically.

After doing some reading, I found suggestions of using GotFocus() event and Me. Requery to update the form but it doesn't seem to be working for me. What am I missing?

Here's the date I'm wishing to update. I would like to add more items to requery but just starting off with the simple date.

 

[CJ_London]

form gotfocus event wont work if it has any visible and enabled controls - which presumably the two buttons are. See this link

Form.GotFocus event (Access)

Office VBA reference topic

docs.microsoft.com

given the date only changes every 24 hours, think you need to define what 'periodically' means

 

[theDBguy]

Hmm, exactly "when" do you want the update to happen (automatically)?

 

[pbaldy]

A couple of other thoughts. I might try the activate event rather than the focus event, or maybe the timer event if you want it on some sort of schedule. For the textbox, you may need to requery the textbox rather than the form, since it isn't displaying something in the form's record source..

 

[eibyer_apc]

Ah, that makes sense. I have these queries on the form also that I'd like to update. I can make a refresh button but if possible, I'd prefer it to be automatic or maybe even a set interval.

 

[eibyer_apc]

For the textbox, you may need to requery the textbox rather than the form

This worked great! Thanks

 

[pbaldy]

Happy to help! If you want it done at a set interval, take a look at the timer event of the form.

 

[eibyer_apc]

Happy to help! If you want it done at a set interval, take a look at the timer event of the form.

That's exactly what I did. I had played with On Timer event before I tried GotFocus, your hint got me into the right direction.