Refresh issue? (1 Viewer)

[MikeG]

Good day all!

I have a field on my form based upon a parameter query to assist the data entry person. Because of the number of entries possible, I thought it might be a good idea to narrow the possible selections based upon a possible name string e.g. I used LIKE "*" & [Enter some portion of the firm name to search on:] & "*" in the specific field criteria of that underlying query. The question I have is: after the first record is built and the field is filled, what do I need to do to get the same prompt in the next record? Only by exiting and re-entering do I get the prompt again. I'm not VB event proficient yet so I hope someone has seen this scenario before.

Thanks in advance.

mg

 

[msp]

Mike,

Have you tried running a requery?

 

[MikeG]

Yes, I tried it with an AfterUpdate event on the field but that forces another prompt because of the parameter query so it can't go there... I think it needs to be on some sort of "current" event so I'm looking at the resources available on that. I just wish I knew more on those underlying events. I know just enough to be in trouble.

Thanks for checking.

mg