By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,526 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

Records in form deleted?

P: 35
I Have a very odd problem, i have entered 30 peoples worth of info into a form, so i save and quit. However when i go back into it only 16 records exist. I think maybe i didnt save it, so i check the tables where i store all of the info and all 30 users exist.

I am very confused about this and is causing a lot of problems. any solutions would be great.

Thanks
Nov 17 '06 #1
Share this Question
Share on Google+
6 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I Have a very odd problem, i have entered 30 peoples worth of info into a form, so i save and quit. However when i go back into it only 16 records exist. I think maybe i didnt save it, so i check the tables where i store all of the info and all 30 users exist.

I am very confused about this and is causing a lot of problems. any solutions would be great.

Thanks
Open the form in design view and open the properties.
Check the form properties under the data tab.
What is the Control Source set to?
What is the Filter set to?
Nov 17 '06 #2

nico5038
Expert 2.5K+
P: 3,072
I would start with checking the filter.
At the bottom of the form you'll see besides the navigationbuttons:
16 (Filtered)
when a filter is active. Click the Filter button at the top to remove such a filter.

Check my description of the right-click popup to learn a bit more about how to filter in Access: www.geocities/nico5038
Nic;o)
Nov 17 '06 #3

P: 35
I would start with checking the filter.
At the bottom of the form you'll see besides the navigationbuttons:
16 (Filtered)
when a filter is active. Click the Filter button at the top to remove such a filter.

Check my description of the right-click popup to learn a bit more about how to filter in Access: www.geocities/nico5038
Nic;o)
I have had a look and their is no filter active. Any other ideas,

Thanks
Nov 17 '06 #4

nico5038
Expert 2.5K+
P: 3,072
Then we need to check the form's recordsource.
Open the properties window (button with hand and white sheet) and the first field under the Data tab will hold a SELECT or a query.
When it's a select, copy/paste that here so we can have a look.
When it's a queryname, then open the query by pressing the [...] button after the field and switch to the SQL to copy/paste that.

Nic;o)
Nov 17 '06 #5

P: 35
Then we need to check the form's recordsource.
Open the properties window (button with hand and white sheet) and the first field under the Data tab will hold a SELECT or a query.
When it's a select, copy/paste that here so we can have a look.
When it's a queryname, then open the query by pressing the [...] button after the field and switch to the SQL to copy/paste that.

Nic;o)
Sorted, for some reason if i didnt check a tick box it never enters that data to that table saying user doesn't have it, so i have to have 2 tick boxes. Now all data appears, cheers for the help anyway
Nov 17 '06 #6

PEB
Expert 100+
P: 1,418
PEB
Is there any code that changes the recordsource property during the work with the form?
Nov 18 '06 #7

Post your reply

Sign in to post your reply or Sign up for a free account.