form doesn't reflect source table updates

[Guest]

quite simply, I added a new record to the source table and it hasn't appeared
in the form which is based on that table. (which is in single form view) I'm
at a loss, but if i can't add new records like this my db is pretty much
useless. I have deletions and additions enabled in the form's properties and
edits and data entry disabled (as I don't need to add records from form view)

any thoughts? help greatly appreciated

cheers

Jake

 

[Alex White MCDBA MCSE]

Was the data added via code and not bound controls on the form?

if so you need to issue a me.Requery on the form for the underlying
recordset to be requeried, also if you have filters applied and the new
record does not meet the criteria then the new data will not show.

Post back if you are still having problems.

 

[Guest]

Hi Alex

how does a me.requery work? are there any additional statements to that? I
have tried inserting just "me.requery" in the event procedure for the form
and it doesn't have the desired effect (although it seems to be doing
something). Do I need to specify the source table again?

FYI the data was entered directly into the table. In the past updates have
always shown up straight away, even to the extend of adding an extra field,
but this is the first time I have added a whole new record. The record that i
deleted (i was replacing an old supplier with a new one) has duly disappeared
from the form view but the new one has failed to appear. The new record has a
new autonumber ID (the primary key field for this table). I had tried using
the same ID# as the old record, but that didn't work either. Sorry if that's
a bit too much info, I'm just hoping to cover all bases.

thanks a lot for your help

jake

 

[adsl]

quite simply, I added a new record to the source table and it hasn't
appeared
in the form which is based on that table. (which is in single form view)
I'm
at a loss, but if i can't add new records like this my db is pretty much
useless. I have deletions and additions enabled in the form's properties
and
edits and data entry disabled (as I don't need to add records from form
view)

any thoughts? help greatly appreciated

cheers

Jake

 

[adsl]

Was the data added via code and not bound controls on the form?

if so you need to issue a me.Requery on the form for the underlying
recordset to be requeried, also if you have filters applied and the new
record does not meet the criteria then the new data will not show.

Post back if you are still having problems.

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk