Form Opens Blank (No controls visible) 1

[dragongunner0351]

Hello all I have a form that opens fine when viewing previous record entries. However when I open the form to create a new record it loads blank. Any ideas why? The form is opening based off of a command button control. One control is "View Previous Orders" (This control loads the form properly) the other control is "Create New Order" (This control loads a blank form)

Thanks in advance to any replies

 

[PHV]

What is the value of the AllowAdditions property of this form ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dragongunner0351]

AllowAdditions Property is set to YES

 

[TheAceMan1]

How are ya dragongunner0351 . . .

Your probably setting the 5th argue of DoCmd.OpenForm to [blue]acFormAdd[/blue]:

[blue]      DoCmd.OpenForm "frmSchedule", acNormal, , , [purple][b]acFormAdd[/b][/purple][/blue]

[blue]acFormAdd[/blue] sets the [blue]Data Entry[/blue] property of the opened form to yes. It is this property thats giving you the single blank line as this is the function of [blue]Data Entry[/blue]. Its good for restricting users to [blue]data entry only![/blue]

If you have to see previous records you need something like:

[blue]   DoCmd.OpenForm "[purple][b][i]FormName[/i][/b][/purple]", acNormal
   DoEvents
   DoCmd.RunCommand acCmdRecordsGoToNew[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

 

[dragongunner0351]

I've tried all of your suggestions and nothing seems to be working. I'm going to look over some of the SQL and see if anything is messed up. If you have any other suggestions Im game.

Thanks

 

[dragongunner0351]

This is a little strange but, When the form loads blank and I click on the design button it takes me to the form in design view which is normal but when i return to form view it opens the form and shows all records attached to that customer.

 

[TheAceMan1]

Have a look here: Why does my form go completely blank?

See Ya! . . . . . .

 

[dragongunner0351]

Thankyou AceMan1 I will check out that link

 

[straybullet]

Wonderful link AceMan! Thank you!

Let them hate - so long as they fear... Lucius Accius

 

[dragongunner0351]

Thanks for all the help. I found i had a criteria that wasn't jiving right with the two forms. I have since removed the criteria and now when i go to create a new order it opens the form and show all records for all customers.
Originally I wasn't trying to link by CustomerID which is a common field between the Orders Form and The Orders By Customer form.

For example,
Open Form Select company name from unbound drop down list.
Next you have two options
1. View all previous orders pertaining to this customer (not working anymore, since criteria was removed)
2. Click on command button to create new order.