HELP! Losing Data

  • Thread starter Thread starter mamajot
  • Start date Start date
M

mamajot

Access data base is losing information. You can type in a
form but it is dropping information.
 
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.
 
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.
 
You must log in or register to reply here.

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

Windows 11 Windows 11 update 5
How to Convert EML to PST? 2
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 1
losing some parts of DB 2
Insert multiple .dat files into one pdf without losing color of their graphs 0
Adding and Deleting Phrases from drop-down menus 5
Wrong Data Type 4
Convert Number Field to Date in Table 4

Back
Top