Blank form

[BAzZ]

I had a form based on query, to enter data in, it was displaying everything fine, I have since done something, which I don't know what, and now everytime I open the form it opens blank with no fields at all. I have checked filters and none are set. If I enter data directly in to the table the form displays the entered data, but I can't add a new record.

I created a new form based on the same query and it opened fine, allowing me to add records, but I would rather use the form that I have already set up as it has command buttons, drop down lists and sub forms already setup, as it was previously working.

 

[soundsfishy]

Hi Bazz

This may sound stupid by are you that you are opening the right form.

 

[BAzZ]

Yeah its deffinitely the right form, its the one I was working on before I did, whatever it was I did. In design view all the fields, subforms, command buttons and drop down lists are there, This form is like the Main form which data is to be entered into.

 

[soundsfishy]

This is just a thought!
Could it be possible that all your controls have been set invisible.

Check each of the field on the form and see if they are set to NO. If this is the case, set them back to YES.

Is there anything in the OnOpen of event of the Form or have you tried creating another form using the same field.

If this doesnt help, maybe some else may post a reply to your problem. You might even have to attached a copy of the DB for someone to have a look at.

Im sure there someone here who post the solution.

 

[BAzZ]

none of that was set. I hope some one will be able to help,

Cheers

 

[cesarney]

empty form

hi

look at the dataentry property of the form..

if is set to yes change it...

bye


cesarney

 

[soundsfishy]

If none of the suggestions help, you might want take a closer look at the query that the form is based on.

 

[BAzZ]

dataentry property is set to no, If I create another form like the previous form it shows the fields, like it should, the other form was working fine, I would rather get that one working again rather than re-coding the new form.

The query is just based on the table

 

[andrewf10]

I've seen this before when running my database with security.

If you log on a read-only user and the table has no records, all the controls on the form will be invisible.

Long shot but...