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

dawid505

New member
Local time
Today, 08:30
Joined
May 19, 2022
Messages
2
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

Well-known member
Local time
Today, 02:30
Joined
Apr 9, 2015
Messages
4,102
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

Super Moderator
Staff member
Local time
Today, 02:30
Joined
Feb 19, 2002
Messages
36,296
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.
 

Users who are viewing this thread

Top Bottom