Data control difference from the form and the navigation control

[The]

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:

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?

[June7]

Review https://www.accessforums.net/forms/t...orm-32053.html

[The]

Thanks

That was useful