I have created a form that queries and number off a table and brings with it certain information that populated other text boxes. When I switch from design view to regular, none of my text boxes show up. Can anyone help?
I dont think the query would have anything to do with the textboxes showing up. Now whether or not there was data in the boxes would have to do with the query. Could you make an sample of your database and post it, or post the whole thing so I can see if I get the same thing?
I actually can't do it b/c of sensitive info. Let me tell you what my project is based on. I need to create a form that queries a specific number and brings back 3 to 4 other columns that are associated with that unique number. At this point the user can add information to the forms through combo boxes and what not. At that point the user presses a button and writes all of the information to a new table. Do you have any shell programs that do that type of work? I know its a long shot but who knows.
In Access 97, if you have a bound form and the record source returns no records, it will actually give you a blank detail, even if the controls are set to visible.
This is actually a pretty significant issue, because there are a lot of other things that tag along - for example, becasue there's no data, all of the events relating to record movement will not fire (such as the "On_Current" event).
Unfortunatley, there isn't a "fix" for this - you have to program around it, which varies depending on your circumstances. One thing that will help, though, is to give your users some options when there is no data - just make sure the options are in the form's header and footer so they stay visible!