Opening a form

[ItIsHardToProgram]

I have a command that opens a form from a main form(the form is not defined has subform, and I don't want it to be) When I open the form, it shows has blank... there is a many to one to many relationship between That form, the main form, and a subform.... can Any one help with that problem????? or have any clue why I get such a weird formating.... I tried modalizing or changing the attributes, but nothing does it. Thanks for your help

 

[ItIsHardToProgram]

Hey I have isolated my problem but don't know how to fix it, It seems that when I link my form to a query that uses the 2 tables in relation (one to many), my form appears has blank for some reason, does any one know why??? thank a bunch.

 

[dlamarche]

I have this problem sometime. For me it is always because the DataEntry and AllowAddition form properties are not set properly.

Check both to see if they are what you expect.

Daniel

 

[Ascentient]

Confirm that your query has data too! I often find I have messed up my query. (I am not sure how, but I do.)

 

[ItIsHardToProgram]

I found the problem, but thanks for your help. If any one encounter this, try seeing if your query works properly, if your query uses 2 tables that have common handles somewhere in them, access will not be able to read it......
I just deleted the query and used a table, was working fine except now i have entrys repeating themselves in both table.... if some one knew how to get around that, would help.