Some Query Fields not Appearing on Form

[jlfvlf]

I have a query that has two tables linked many to one. When I view the query results, all four field(three from table A and one from table B are visible. When I pull the query into the form, the three from table A are populated in text boxes but the field from table B is blank. Please help.

 

[June7]

Why are you using a one-to-many query as form RecordSource?

If you want to provide db for analysis, follow instructions at bottom of my post.

 

[jlfvlf]

I am wanting to view the description of an item in table B that is linked to table A which contains the auto id.

 

[June7]

@Pat Hartman, I know form can have 1-m query as RecordSource but I have seen enough posters do this when it wasn't necessary and got themselves into difficulties. So I asked why they are doing it. An alternative approach would involve multi-column combobox and expression in textbox referencing combobox column.

@jifvlf, that query is fine as long as you don't allow edits to fields from the lookup table (TableB ?). Set controls as Locked Yes and TabStop No.

I still can't explain why your form has issue with displaying TableB data. Again, if you want to provide db ...

 

[arnelgp]

check if the subform created a Master/Child link fields.

 

[June7]

Subform was not mentioned in OP. But I suppose that could be component of issue.

 

[arnelgp]

maybe not, but when you "pull" something into the form.

 

[jlfvlf]

Thanks for the help. June7, I will try the Locked Yes and Tabstop No when I get to work in the morning. It is working at home on a two simple tables and a query, but at work there are many more columns in each table so I will start from the basics and try to figure it out. I don't need to do edits, I just want to view. I will let you know when I am at work and maybe get it to show correctly. Thanks again.