Values not being inserted into the tables from form

[sabre1]

I have a form which has multiple tabs and on each tab there are fields which are from multiple tables. I have a combo box on the first tab which successfully finds all the fields information as i have linked all the tables by the Entity_ID which is common in all the tables. However when adding in some information into the form, the Entity_ID is not inserted into the tables and therefore when using the combobox again which uses the Entity_ID the information does not come up. If anyone could shed any light on this problem i would greatly appreciate it, let me know if you need this explained further.
Thanks.

[RuralGuy]

A form can only have one RecordSource unless you are using SubForms on your tabs. Is that the case?

[NTC]

info not writing to a record - may be cause by leaving the form when the record is still in write mode (a pencil icon to the left of the record). In write mode it is considered 'dirty'. You can force a me.dirty=false on form close event or some other event relevant to what you believe is appropriate.

info not appearing in a combobox is because when the form originally opens it pulls in that data. an update/add will not be reflected. so you must requery that combobox.

Hope this helps.

[sabre1]

Thanks so much, it was because i was trying to have more than one record source, i put my fields into subforms within the tabs and linked them and it now works great, thank you very much for your quick reply and your help.

[RuralGuy]

Excellent! Ready to use the Thread Tools and mark this thread as Solved?