Problems with updatable query and underlying tables

[Drenda]

Can anyone help with the following

I have a form based on a table that I am opening and through setting the record source can open the form in two ways, these being a new record and a record partly completed

1. The new form based on the underlying table - no problem
2. The form in mid - completion is based on an underlying query that filters the data from the same table.

At the moment I am typing line after line of criteria (Building Names) in the query design grid and the resulting record is updatable but if a user adds a new building name to the database I will have to type the new building name as new criteria in the query design grid

There is another way to do it by using two tables to filter the criteria but then the resulting record is not updatable

Does anyone know of a way around this

Thanks

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Drenda]

This Help Was great Many Thanks