I have four different forms to add/Edit data.
I build new form that has a Navigation control. That Main form now has all other form as tabs. Some field in the forms using code like this:
Code:
SELECT Floors.F_ID, Floors.Floor, Floors.B_ID FROM Floors WHERE (((Floors.B_ID)=Forms![New_Tenants]!B_ID));
I use that code in Data > row source
and it works just fine, in the original form, but not in the Main form when I use the form as tab. In the main form, I got dialog ask me to input the value: Forms![New_Tenants]!B_ID
Can you help me please overcome this issue?