Form Contents Disappear In Form View

[cpepper5702]

Hello everyone,

I seem to be having an issue with a split form I've been working on. I created this split form on Monday and it was working just fine but today, I have added a couple minor text boxes. Since then, I can view the form contents in Design View but when I switch to "Form View" or "Layout View", it's all gone minus the logo in the top left courner and the title for the split form.

I searched for it online and couldn't come up with anything related to this. I could have been to specific in Google though. Any help would be GREAT!

 

[cpepper5702]

forgot to mention, when I tried to delete the text boxes I added to it to see if that would fix the issue, the form was still blank in "Form View" and "Layout View". Thanks again.

-Colton

 

[Mihail]

Check the visibilities for all sections.

 

[cpepper5702]

That was the first thing I thought of. Thinking that I may have changed the setting by accident. But when I checked it, they all are set to "Always". It would make sense because again, I can view the forms header but nothing in the detail portion. Also something else that is interesting, I have a formula at the top that simply gives you todays date and that isn't showing up. The box where it is supposed to be is there but not the formula "=Now()".

This all started once I created an expression between one forms unbound text box to one on the form that's now blank. I was wanting to have a textbox in the form that is being discussed, reflect what was typed in the other box. For example in Excel, you can select a cell and type "=G7" and from that point, that cell will always say whats in G7.

 

[Mihail]

Hard to say what is happen.
If you can to upload the database, maybe someone can find a solution.

A quick question:
Is a hard work to redesign that form from scratch?

 

[cpepper5702]

It's not that difficult to recreate it, it's just time consuming. I would love to post it on here but it's on an intranet network so I can't turn it out to the public internet. Am I going about it the right way by building an expression to show whats in a text box from a different form? I wish it was as easy as my Excel example above lol.

 

[cpepper5702]

Okay I figured out whats causing the issue. But I just don't know how to fix it.

I used the form wizard to create a new form. When I told it to grab all the fields from one table to and two fields from another table, it doesnt display anything again. So seems like it doesn't like to take fields from multiple tables.

 

[Mihail]

That mean that is nothing to display.
Copy the record source of form then paste as SQL in a query.
The query will not show any record.

 

[cpepper5702]

Hmm... I will try to figure that out. I'm already halfway through recreating the form. I'm just staying away from adding those fields in from the other table. Do you have any suggestions on how to make a text box mirror what another text box says in a different form?

 

[Mihail]

In textbox controlsource:
=Forms!TheOtherFormName!TheOtherTextboxName

 

[cpepper5702]

I tried that expression before and it didn't work. In the text box it says "#Error". It automatically puts the brackets around it so when I type it out the way you did, it corrects it to
=[Forms]![CurrentVersion_Mirror]![CurrentENGINEVersion_txt]

I double checked the names of each textbox and everything looks good. The expression also looks good but I can't figure out why it's giving me an error. I tried to Google how to do this but nothing is specific to my issue. Thanks.


-Colton

 

[SOS]

Okay I figured out whats causing the issue. But I just don't know how to fix it.

I used the form wizard to create a new form. When I told it to grab all the fields from one table to and two fields from another table, it doesnt display anything again. So seems like it doesn't like to take fields from multiple tables.

Why do you need multiple tables? One thing to take notice of is that you don't need to include lookup tables in your record source in order to display the values on the form. You can use a combo box to display the text values for id's if that is what you were adding those other fields for.

But to use the other table, if you truly needed to add/edit data there, would require more than the two fields. It would require the PK field as well. But I would use a subform to have that available.

 

[JHB]

I tried that expression before and it didn't work. In the text box it says "#Error". It automatically puts the brackets around it so when I type it out the way you did, it corrects it to
=[Forms]![CurrentVersion_Mirror]![CurrentENGINEVersion_txt]

Is it a textcontrol, combo box or list box?
If combobox the add .[Text] to the controlsource.

=[Forms]![CurrentVersion_Mirror]![CurrentENGINEVersion_txt].[Text]