I need to delete a record that was entered on a form - then is stored in two different tables.
one of the tables is empty
when i try to delete the record it tells me that it has info in another table...
when i go to that table it tells me that the search field is empty - and can not delete it.
if i try to enter data - it closes access completely...

please help

thanks,

Hmmmm... When you say that the record is stored in two different tables, how is that setup and is there a relationship between the tables?

I ran into something like this a few days back, so I feel your frustration!!

Mike
EchoVue.com

background - data entry is done on a form (that has subforms) the link to all tables is the unique ID field -
however in this case the WO table has an ID field - the APP table is empty no ID field -

not sure what to do in order to delete or access this form/record???

thanks,

Look at the properties for the Form. My guess would be that the RecordSource under the Data Tab is a query. Try and delete the record from the Query, that should around any relationships set up between the 2 tables involved. If not we can try something else.

Mike

Mike
EchoVue.com

Mike Thanks...
the record source is the APP table - not a query
when i look at the table - this record is empty and it says the "search field is empty"
thanks,