I've created a simple form that runs a query based on the combo box selection and text box field. Yesterday it worked fine. Today when I open it in Form View, it is blank. The fields still show up in design view. I'm confused why it doesn't work today since I didn't change anything. I've attached a screenshot.
Form fields not showing
- Thread starter camg12
- Start date
With all due respect to Bob, if the form is not bound to a data source and the combo box and the text box are both "unbound" as they indicate that they are, about the only thing that could cause controls to not display is if the "visible" property is set to "no" but I would assume that you have checked that.
You did not indicate what version of Access you are using but I did a quick test here in 2007 and could not duplicate any behavior like you describe.
Perhaps you could create a new database and import this one form to that new database and then post it here so we can see what is going on.
You did not indicate what version of Access you are using but I did a quick test here in 2007 and could not duplicate any behavior like you describe.
Perhaps you could create a new database and import this one form to that new database and then post it here so we can see what is going on.
I'm using Access 2007. The query is built on linked tables. I have [Forms]![FormName]![ListName] and [Forms]![FormName]![TextName]
in the criteria field of the query. This works but when I close and reopen the database, the Form goes blank.
To fix this issue, I've had to manually go into the query and delete the criteria out of these two fields, re-run the query, then I can use the form again.
in the criteria field of the query. This works but when I close and reopen the database, the Form goes blank.
To fix this issue, I've had to manually go into the query and delete the criteria out of these two fields, re-run the query, then I can use the form again.
jdcallejas
Registered User.
- Local time
- Today, 07:16
- Joined
- Jul 1, 2008
- Messages
- 108
Hello there,
It took me a while to find this thread, I have a similar issue.
I am using MS Access 2010. I have finished creating a database for my company, everything seems to be working fine, all forms, queries, and reports are doing what they are supposed to do.
Now that I want to implement the database into the business I need to split the database and create a BE and the FE because I want each department to have only the forms and reports they need to use.
I have done this back in the year 2001 with MS Access 2003 I think, and this forum made it possible to make a great program. I created the BE and I just placed the forms, queries and reports to each PC per department. I then just linked the FE to the BE and everything worked fine.
So, I did the same with this database, to avoid latency I bought a brand new, top of the line CPU to place the BE and only to be used for this. I also bought a Gigabyte switch and upgraded all PC’s to have a Gigabyte Ethernet card. The network is FAST.
My Procedures;
1. Split the database to have a BE and FE
2. Placed BE on the Server
3. Placed FE for each department, each department opens up on its own menu.
4. Linked the FE to the BE tables.
All this was done successfully.
Here is where I encounter similar issues like you guys are talking about here.
When I open any form on the server side FE that is also linked to the database all works fine, but if I want to open a form on another PC on the network, then the form has a blank space where the fields are supposed to be.
After reading here I tested putting a record on the table, I tested the form and I was able to see the record on the form, but if I open that same form on another PC, the form was back to blank.
It’s like if I want multiple users to use the database for data entry or whatever the database is locking up or something.
Something else I encounter, I inputed multiple records on different tables, when I open the forms that are linked to its recordset, I am able to navigate to last, first, next, previous records, but if I click on new record, I get the error “ You can’t go to the specific record” it does not let me add new records.
So what I have been doing is letting my employees input the information directly on the Server PC, which defeats the purpose of the program.
I have attached a copy of my database/program and also some images of how the forms look when they are blank.
I have read and tested some suggestions I have seen online but I can’t get it to work.
I would greatly appreciate if someone took the time to guide me or show me what I am doing wrong.
It took me a while to find this thread, I have a similar issue.
I am using MS Access 2010. I have finished creating a database for my company, everything seems to be working fine, all forms, queries, and reports are doing what they are supposed to do.
Now that I want to implement the database into the business I need to split the database and create a BE and the FE because I want each department to have only the forms and reports they need to use.
I have done this back in the year 2001 with MS Access 2003 I think, and this forum made it possible to make a great program. I created the BE and I just placed the forms, queries and reports to each PC per department. I then just linked the FE to the BE and everything worked fine.
So, I did the same with this database, to avoid latency I bought a brand new, top of the line CPU to place the BE and only to be used for this. I also bought a Gigabyte switch and upgraded all PC’s to have a Gigabyte Ethernet card. The network is FAST.
My Procedures;
1. Split the database to have a BE and FE
2. Placed BE on the Server
3. Placed FE for each department, each department opens up on its own menu.
4. Linked the FE to the BE tables.
All this was done successfully.
Here is where I encounter similar issues like you guys are talking about here.
When I open any form on the server side FE that is also linked to the database all works fine, but if I want to open a form on another PC on the network, then the form has a blank space where the fields are supposed to be.
After reading here I tested putting a record on the table, I tested the form and I was able to see the record on the form, but if I open that same form on another PC, the form was back to blank.
It’s like if I want multiple users to use the database for data entry or whatever the database is locking up or something.
Something else I encounter, I inputed multiple records on different tables, when I open the forms that are linked to its recordset, I am able to navigate to last, first, next, previous records, but if I click on new record, I get the error “ You can’t go to the specific record” it does not let me add new records.
So what I have been doing is letting my employees input the information directly on the Server PC, which defeats the purpose of the program.
I have attached a copy of my database/program and also some images of how the forms look when they are blank.
I have read and tested some suggestions I have seen online but I can’t get it to work.
I would greatly appreciate if someone took the time to guide me or show me what I am doing wrong.
Attachments
Similar threads
