problem with form (inputting)

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

I have a form tblDISCIPLINE that is based of a qryDISC which is based off
tblDISC

For some reason when I input new discipline records and close the form, then
reopen it they are gone. (I do have 1 update and 1 delete query that run
when the form is open or closed.

I can edit records using this form (that is using a query as the source),
but why can't I add records to the underlying table?

I do have the delete,edit,dataentry etc... set to yes. (I must be
overlooking something).
TIA,
_Bigred
 
Dear Bigred:

It seem odd to use tbl (table?) as a prefix for a form (frm).

Anyway, for your main question, please open the form and add a new row.
Don't close the form yet. Go to the database window, open the table, and
see if the new row is there. Is it not being added, or is it being deleted
after the form is closed?

Tom Ellison
 
table --> query ---> form

when I type stuff in the form it doesn't add the record to the underlying
table. (It will edit existing records, but not add new records) I have form
set to allow deletions, additions, dataentry and edits etc..

Thanks,
_Bigred
 
Back
Top