Windows 7 64bit 
Access 2010 64bit
I am trying to design a database to show all the records when I choose one of the fields using a combo box.
I have tried a couple of methods, but can't get it to work.
1. I created a form with a sub-form and the main form is using the table that contains all of the data, but the Combo boxes record source is the field that I want to use as the source for the search. If I choose an item from the list all it does is change the field that is linked by the master child relationship that I have set in the properties. Even worse than this it also changes the master field to the value of the choice I have made. It only changes the first row in the table.
The main form data source is the table and the sub-form has an SQL query also from the table, presumably created when I used the Form Wizard to create the sub-form.
How do I get all of the form fields to reflect the choice I have made?
Can I make the fields in the sub-form read only?
2. I have also tried to put the combo box in the same form and again only the field I am using to choose the record is being changed. The record source for the form and the combo box is a query.
Can you do what I am trying to achieve?
What I finally want to do, once I have overcome the above problem is to use most of the fields in the chosen record to format a text box in a report, so that the text appears in a particular position on the page, however that may result in another post!
Reply With Quote
