Unable to Edit/Add records on Form in a New ADP

  • Thread starter Thread starter David C. Holley
  • Start date Start date
D

David C. Holley

I just started playing around with rebuilding a MDB file as an ADP. I built
a form and subform from scratch, but I'm unable to edit or add records.

SELECT Id, LoadDate, TrailerDOTNumber, SealNumber, SealDate, SealId,
LoadLocation, LoadStatus, DispatchStatus, DispatchLocationId, DispatchUserId
FROM TrailerActivityHeaders ORDER BY LoadDate

Recordset Type: Updatable Snapshot

I'm getting the 'This recordset is not updatable'

Ideas?
 
Never mind... (Does anyone have a spare bandage btw? I cut my head banging
it on the wall due to my stupidity...)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adp form save\update problems 3
Select multiple records in the datasheet part of split form. 0
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
Filter main form to records with no related records in subform,maintain updateable recordset 4
Add New Record error 2
DAO Add/Edit/Update Methods 6
ADP Main Form Disabled when Editing Subform 4
Add new record from a form to a table, then record new ID 2

Back
Top