If a query pulls together data from many different tables and query combinations, and I can see the data I need in the query, does anyone know why that same data would not show up in a form using that query? Thanks.
If I can see fields in a query, why would they not show up on the form?
Competent Performer
Windows Vista 
Access 2010 32bit
If a query pulls together data from many different tables and query combinations, and I can see the data I need in the query, does anyone know why that same data would not show up in a form using that query? Thanks.
VIP
Windows 7 64bit Access 2010 32bit
Do you build lookups in tables?
Did you bind textboxes to the appropriate fields?
What data is showing?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows Vista Access 2010 32bit
no lookups, yes textboxes are bound to appropriate fields, everything but these 2 fields.
I can add data to the fields in the query.
The form is mega complicated. It is based on a One to many, with numerous many's. And then I am connecting another set of data, including a One to many, with numerous many's. The root of the data I am adding in could be the cause. I have a company with many personnel linked from the personnel table to the Company table (not logical but it all works).
VIP
Windows 7 64bit Access 2010 32bit
Normally a form can do data entry/edit for one table. If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Certain Fields only show #Name? until I run the Record_Source query.
Posting Permissions
Reply With Quote