where does my data go?

[buggirl]

I have been entering data into a form, but some of it is missing (and, yes, I
am sure that I entered data in the first place!). This has happened a couple
of times in two databases, and I don't understand why - I don't even know
where to begin looking for problems in my database design.

The missing data did not turn up in queries, so I checked the original table
that it should be in. It's missing from there too.

Any suggestions would be greatly appreciated.

Thanks,

buggirl

 

[Jeff Boyce]

I can't be sure from your description, but it sounds like you may have it
backwards...

In Access, data lives in tables. That's where it all starts.

Then you can create queries that provide something like a "view" of the data
in the tables. That view may or may not allow you to change data, but the
data changes would be in the tables.

Finally, Access forms display data, either directly from tables or
indirectly via queries. But for forms to do this, the controls on the form
must be "bound" to the underlying field that stores the data.

That is, you can add a whole bunch of controls onto a form, but if you never
connect them to a field in a table or a query, the data you put there never
goes to the table.

Any chance that's what's been happening? (you can check by inspecting each
of those controls on your form to see if the property Control Source has a
fieldname in it.)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[arlene ramirez]

subed going to jail

 

[Larry Linson]

subed going to jail

Is it possible that, even after you have been told many times, nobody here
knows what the heck you are talking about? I'd add that, even if we did,
the probability is negligible that we'd have any interest in it, unless it
relates directly to Microsoft Access database software.

It is, of course, possible that you were looking for a chat newsgroup, or
just "access to the Internet" but what you have found is a newsgroup for
technical discussion of and questions and answers about Microsoft Access
database software. It is easy to be misled by the online interface that you
are using.

Larry Linson
Microsoft Office Access MVP

 

[buggirl]

thanks - I think the design of my form was the problem. Things are working
again! Hooray!

 

[De Jager]

thanks - I think the design of my form was the problem. Things are working
again! Hooray!

 

[joelgeraldine]

gn;lbvnb

thanks - I think the design of my form was the problem. Things are working
again! Hooray!