Form is not loading

[sp1260]

I have database that I created a Macro to load a form in the add mode. However, when I split the database the form stopped loading. However if I add the form in the edit mode is seem to load but I need it to open with a new record form. Can you put the condition new to open the form with a new form.

HELP!
Same problem:
I have a button on my switchboard that when clicked runs a macro that I have created to open my form in "Add" Data mode. It worked fine until we put the database on the network and split it to a front end and back end database. Now when you click the button on the switchboard the Detail part of the form does not show up.

 

[pbaldy]

If it opens with the controls not showing, the usual suspect is that the form doesn't allow additions. Can you add a record via the form's source table/query directly?

 

[sneuberg]

I suggest trying to open the linked tables related to these forms and make sure the data is showing up ok.

 

[pbaldy]

I interpreted this as existing records show fine:

"form in the edit mode is seem to load"

 

[sneuberg]

I interpreted this as existing records show fine:

"form in the edit mode is seem to load"

That make sense but I'm confused about this happening seemingly because of the splitting of the database.

 

[sp1260]

I detected that the macro for the add form is not working properly. What I did was install the edit macro which works but it trying to make it prompt to a new record when the user open the Add new record command button. The end users get an error message cannot go to a specific record. click ok then open form with existing data.

 

[pbaldy]

So I'll ask again:

Can you add a record via the form's source table/query directly?

 

[sp1260]

So I'll ask again:

Yes, I can enter a record through both (form and table).

 

[pbaldy]

With the form too? The add records icon appears to be disabled, and you get an error trying to go to a new record. Is the Allow Additions property of the form Yes? Can you attach the db here?

 

[sp1260]

thank you so much for the help. I really don't feel comfortable uploading the database since it contain the local government data I work for. I decided to put customized navigation buttons which is working so far. However, it has too be something in the macro settings. Some of the end users is having problems with the new record command buttons. I have check the trust center settings. Attached are some print screens of the form. The allow additions is set to Yes.

Thank you!