Now that's something I've never seen before

[commanderrico]

I created a form using the wizard. It has parts from two tables on it, so it has a subform. When I click finish on the wizard nothing shows up on the form. All I see is the background from the autoformat. When I go to design view everything is there like it should be but when in form view nothing shows up. Everything is visible so I can't figure out why this is. Any thoughts?

Rico

 

[scriverb]

Delete the form and redo. Obviously, something went haywire with the wizard creating this form. Who's to know why??

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[NorthNone]

- - A whole section (detail for example) can be set to Visible=False. That was the only way I could get a form to appear with nothing on it. Did you check that?
- - Any form load code running that could be affecting this?
- - Couldn't figure out how the form wizard in one pass could create a form and a subform so I couldn't reproduce that.
HTH
JeanS

 

[amcodah]

1.Make two seperate forms with the wizard.
2.Check that both forms work fine before doing anything else.
3.Then open the form you want as mainform and drag and drop the other form (subform) into the mainform.

Hope that helps
~am()

 

[NorthNone]

amcodah...can the Wizard create the form and subform in just one pass or do you have to go through the steps?

 

[commanderrico]

Usually I create the form and subform in one shot with the wizard but I can't get it to do it today. Usually when you select two or more tables it'll give the option to create a mainform or a mainform and a subform. Must be cranky today cause I can't get it to work. Probably operator error but we'll blame the computer for now.

Rico

 

[amcodah]

Yes NorthNone, the wizard can do that. I'm a person that doesn't like the wizard so I do all forms etc manually Gives me better control of everything.

Commanderrico: You don't base your forms on a query/view? I always do. So then I'd advise you to create 2 queries/views and check that each one displays some data before building forms.

Cause I think this also can be caused by a wrong JOIN between you'r two tables, hence the form not showing up. Just try it, make a form that is based on a input value of ID. Then send the ID = -1 (for example, any ID that doesn't exist in the table would do). And see what happens.

Have you tried changing you'r tables relations to a LEFT or RIGHT join? (INNER JOIN) is default in MS Access. That could might help you do the trick. You can do it Tools-View Relations, rightclick a relationship and select propeteries. Select JOIN TYPE.

If you want to see what this does, create a simple query/view and then view the SQL code. The default database would have INNER JOINS, but change it and the SQL code would show you LEFT/RIGHT JOINS.

 

[amcodah]

Yes NorthNone, the wizard can do that. I'm a person that doesn't like the wizard so I do all forms etc manually Gives me better control of everything.

Commanderrico: You don't base your forms on a query/view? I always do. So then I'd advise you to create 2 queries/views and check that each one displays some data before building forms.

Cause I think this also can be caused by a wrong JOIN between you'r two tables, hence the form not showing up. Just try it, make a form that is based on a input value of ID. Then send the ID = -1 (for example, any ID that doesn't exist in the table would do). And see what happens.

Have you tried changing you'r tables relations to a LEFT or RIGHT join? (INNER JOIN) is default in MS Access. That could might help you do the trick. You can do it Tools-View Relations, rightclick a relationship and select propeteries. Select JOIN TYPE.

If you want to see what this does, create a simple query/view and then view the SQL code. The default database would have INNER JOINS, but change it and the SQL code would show you LEFT/RIGHT JOINS.

 

[MichaelRed]

this can (does) easily occur if the recordsource for the form returns no records.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[missinglinq]

MichaelRed's right. My first thought was that no records were returned, which just gives you the form background without any fields/bound controls being visible.

The Missinglinq

"It's got to be the going,
not the getting there that's good!"
-Harry Chapin