Search results

You should check to make sure no issues for him should his version be a lower version. Edit: Forgot to add... good to hear.

I have received MDB's that I need to *un-brick* because it would no longer open in the new version of Access, so, from experience. 99% of the time it's because of a Reference issue or an ActiveX that was used. Not sure about the millions but I have gotten my fair share. You lose nothing by...

It's not change you should be worried about it's that one day you may not be able to open your database.

Well, not sure what you are even doing. Both of these take up the entire screen so how can it query a Form not open? If you are clipping back and forth then once you enter the Container No the record may not be committed (save) to get the value for it to be re-queried. May you can help us out...

Hmm, if you are modifying this database then if other person has to use it it might be a problem. Anything you do in the latest version may not be available in 2003. I'd be very careful.

Oh okay. Perhaps you could start with posting your Relationships diagram.

Yes, requery itself and since you are doing so you cannot put the Form name there. You need to put exactly what I put in the On_Click event. If that works then it's probably not doing from the Main Form because data not saved yet. If that is not working please post the Row Source of the combo...

Hmm, try putting... Me.cboContainerNo.Reuery in the On_Click event of cboContainerNo.

Hmm, can you post a screenshot of the Properties window? Oh, and is Transparent set to *No*?

<---from Ohio Welcome to the Forum!

Hmm, this kind of makes my *argument* that we don't even understand ourselves. So, if instructions, no matter what, were included in the persons native tongue what is the harm? I don't consider providing one's native tongue to be insulting. Nor do I consider Ebonics a *language*, it's a...

@Pat Hartman I live in Ohio though it was same in New York but you needed a *reason* to request an absentee ballot. Though with the current pandemic the Governor has said no reason\excuse needed to request an absentee ballot for this election. There is no receipt cut-off date which is one of...

I vote by absentee ballot and have been doing so for years. That said, I actually prefer paper, can't be hacked. So, until some *real* election security is passed I'll keep using paper. That said, before the automated voting machines came into play no one's ballot was secret, someone had to...

Well, not usual to have that many combo boxes dependent on the main Form. So, I've never tried that many requeries. All I can say is try it.

Ouch, that is going to painful for some as not everything moves over nicely.

Hmm, just a side note, 32 bit Access is not *legacy*, it is, in fact, recommended by Microsoft. So why would you migrate your applications to 64 bit?

Hmm, so I added a... Me.ServiceID.Requery ...to the On_Current event of the Subform and it appears to do what you want. That said, I would use tables to hold combo box values instead of Value Lists. If you ever need to make a change it's easier to add to a table then to keep going into deign...

Welcome to the Forum! Perhaps this will help... https://www.access-diva.com/vba20.html

Welcome to the Forum!

Welcome to the Forum!