HELP! Losing Data

M

mamajot

Access data base is losing information. You can type in a
form but it is dropping information.
 
G

Guest

hi,
could you be a bit more specific.
what verion access are you using?
Is it a bound form?
when did this start?
how long have you been using this form?
Is your data base pc confined or does it shoot data over a
network?
The more info you supply, the better we are able to help.
 
A

Allen Browne

Is it actually a subform that is losing the information?

If so, open the subform's table directly, and you will probably find that
the entries are there, but the foreign key field is Null. That means they do
not match any record in the main form, so - even though they are there in
the table - they never show up in the subform again. To prevent that form
happening, set the foreign key field's Required proeperty to Yes (in table
design).

If is is not a subform, what is the RecordSource for your form? A table? A
query? If query, post the SQL of the query.
 
Top