I have everything setup in Access 2007. When I go to my form view, not all my database shows up. I feel there is a break somewhere but I am new to Access and need help.
-
-
You don't provide much information for us to go off of, but here are a few places to look.
Does your form have anything in its Filter property?
Is your form's Record Source a table or query or a SQL string?
If it is a query or a SQL string, is there a WHERE clause in either one?
While I'm guessing not, is there any code in the form's events (On_Load, On_Current, etc.) that could filter the results? -
Steve I am so new to this. It was created before I started to work here. It was working fine about 8 months but when we went to put a new contact in and save - It saved it to our database but will not show on the formComment
-
Seth this is a query and on the form property sheet under event there is nothing in "on Current" or "on Load".Comment
-
Go into design view on the query and see if there is any criteria listed. Also, did you look in the form's Filter property?Comment
-
Seth is this on the property sheet of the form? I don't see themComment
-
Yes, in the Data tab of the property sheet.Comment
-
I see no criteria fieldComment
-
The form property is called Filter. In the query it is called criteria.Comment
-
ok I see Filter but where do I see queryComment
-
If you click inside the Record Source property, you should be able to click on the ellipsis button (three dots), which should open the query.Comment
-
Ok I see criteria and the line is blankComment
-
Of course. That would be too easy :).
This is a bit of a stretch, but while looking at the query in design view, switch to SQL view (Design tab, far left button of the ribbon) and tell me if you see the word TOP right after the first word SELECT.
Also, switch back to design view on the query. How many tables are shown in the top part of the window?Comment
-
Top is not after select - in design view I have 5 tables on top part and 4 tables below themComment
-
Ok. You say that the new contact did save in the database. Can you look for that record in the main table and see if there are any blank fields?Comment
Comment