combo does not go into table field unless you select it twice?

[d9pierce1]

NewBusiness - Copy.zip

Hi all,


Can someone please tell me why when I select from a combo in my subform (the only combo in subform) I Have to choose twice in succession to get it to go into table?
db Attached, opens to form with sub form on it.

Thanks
dave

[Welshgasman]

Not yet, but when I selected another category in the main form, it wiped out the combos in the subform?
Not sure a Requery is required?

Edit: In fact I am unable to select a second time where the data actually stays in the combo?
In fact I cannot change a lot of the properties of the subform, control and even in the query source?

[Welshgasman]

Now have it working?
Amended query and commented out the current event and Save Record in Dirty event.

Pretty much hit and miss TBH as the query would not edit correctly anyway?

[d9pierce1]

Hi Welshgasman,
First I want to thank you so much! I do have one question as to what does that Query1 do and where is at in forms?
I went through it and cannot find it anywhere?
Thanks
Dave

[Welshgasman]

Just a query I created to test the source for the combo when the form was open, as the criteria was the mainform combo. You can delete that without any issues.

[d9pierce1]

Again, Thank you very much!
Dave - Marked as solved!

[Welshgasman]

Thoroughly test it, as I just commented out what I thought might be affecting it.

[d9pierce1]

Hi Welshgasman,
I went through it all and had to remove the Call Form_Current in the Form_Dirty and had to untick the Requery in current event as
When I go from record to records it wouldn't update the combo and when i went to previous it would clear out the combo. This all seems to
work now. Again, Thank you. I believe the big issue was the row source where statement.

[Welshgasman]

That is pretty much what I did and just tidied up the query for the combo rowsource?
FWIW I have never used the Dirty event.

Also it not recommended to call a form event directly.
Put the code into a general module and call the code from the current event and anywhere else you need it. You might need to pass the form object when doing that though.