Form bound to query

[RickK]

Could someone help.

When I bind a form to a query, I don't get all records in a lookup field in the form.

When I bind a form to a table, I get all the records in the table.

Any way to bind a lookup field to a form and still see all the records from the table?

Thanks
RickK

 

[goaksmith]

Could you provide a little more detail as to what you are trying to do? If there is no criteria in your query then it should return the same records as in your table.

 

[RickK]

reply

I'm trying to have a lookup field in a form so that you can choose the Last Name from the list of Last names in the table and the form would return the record that matches.

If the user clicked on the dropdown menu in the form, they would see a list of all of the Last names, and then they would pick one of the last names and the remaining information from the record would show in the form.

I can get the form to do this when I bind it to a single table. When I bind the form to a query that contains multiple tables with relationships in place and working, the form does not return the record with all the information.

Is this enough, please write back, i'm really desparate at this point.

RickK

 

[samehkh]

Check the type of joins you have in the query. Some records in the table might be missing from the query result because you are joining on a field that has a null value, for example you didnt enter a value for "City" and you are joining to table "Cities".
If you right click on each join, it will give you 3 options on how to filter the result.
If you know you are having null values in some fields that has joins you might need to change the properties of the join accordingly.