Data replacing each other - form based on query (1 Viewer)

[dawid505]

Hello guys!

I'm just starting with access and can't solve this issue.
Form "frmOrderList" based on the "OrderListQ" but "Status Name" comes from "tblStatus".

Can someone help me with that?
How to protect the data from "tblStatus"?

Thank you
Regards/Dawid

 

[Ranman256]

set the form's textbox property:
rowSource = tblStatus (the list to pick from)
controlSource = (the field to save the status In the current record), ...StatusName (if I understand you)

 

[Pat Hartman]

Welcome aboard
I can't hear any sound on the video whether I play the embedded file or open youtube. And the text is hard to read because it is tiny so I'm going to guess.

You are trying to select a status and that is causing the status table to change rather than the order list.

One problem that comes to mind is that you might have the status field on the form bound to the the status table rather than the order list table.

Another is that you have code in the NotInList event that is causing the problem.

Can you post the query used for the form's RecordSource and tell us which field is experiencing the problem.