Navigation Form, Combobox Not Working

[Am4nd4]

Hi, well this is my first time posting in a forum... ever! So if I get this wrong please be nice

Despite me reading 20+ posts on this same issue. I still cannot figure out how to get this working. The combobox in the frmResellerOrders works correctly until I include it in the Navigation form frmMainMenu. Once I include it the navigation form it no longer lets me select a value. I have read numerous articles about using the
Forms!YourMainFormName.YourSubformContainerName.Form.YourControlName

However, none of these seem to mention when and where to use it. Do I put it in the query that the form is linked with or do I need to put it in my form somewhere? I have been trying to fix this off and on for over a week now. It is one of the last parts of my database that I need to get finished by Monday!

I have attached a copy of part of my database with some dummy data. Excuse the colours! It did something strange with those when I copied them over.

The frustrating thing is it probably takes less than 5 mins to fix when you know what you're doing.

Help is much appreciated.
Thanks

 

[CJ_London]

you need to change the allow edits property in the main menu form to true.

These main form properties cascade down to the subforms

 

[Am4nd4]

Oh thank you soooooo much! I cannot believe it was that simple! Wish I had posted sooner

 

[Paul Gonzaga]

you need to change the allow edits property in the main menu form to true.

These main form properties cascade down to the subforms

Hi there,
Am having the same problem and the "Allow Edits" property is set to Yes. Is it that we must use the format mentioned of Forms!YourMainFormName.YourSubformContainerName.Form.YourControlName in conjunction with the "All Edits" =Yes? I just dont want to mess up before knowing the right way...

Thanks for your help

 

[theDBguy]

Hi there,
Am having the same problem and the "Allow Edits" property is set to Yes. Is it that we must use the format mentioned of Forms!YourMainFormName.YourSubformContainerName.Form.YourControlName in conjunction with the "All Edits" =Yes? I just dont want to mess up before knowing the right way...

Thanks for your help

Hi. You could create a backup of your db before trying it out.

PS. This is an old thread. You might consider starting a new topic.

 

[CJ_London]

Is it that we must use the format mentioned of Forms!YourMainFormName.YourSubformContainerName.Form.YourControlName in conjunction with the "All Edits" =Yes?

All depends on where you are referencing yourcontrolname from - see this link

Forms: Refer to Form and Subform properties and controls

Agree with DBG, start a new thread since your problem may not be related to the original post