empty form, even though i added controls.

[fhvac]

i dont know if anyone else has this problem, it makes no sense to me.

on some forms i make and open them up for use and the entire form is empty no conrols or anything. just a big empty grey box. If i click the apply filter button then the controls show up, everything turns into a list box, its useless.

did anyone else have this problem? its very stressful

thanks

 

[DanJR]

The only situation, that I know of, that will make the form appear blank is when 'allow Additions' and 'data entry' properties of a bound form have the following values:
[tt]
Data Entry: Yes
Allow Additions: No
[/tt]
Could you explain your second sentence a little more...how can you click the apply button when the form is completely blank? Does the form contain a subform? Or are you talking about two different forms?

Cheers,
Dan

 

[fhvac]

I was talking about the apply filter button on MS Access' toolbar

 

[DanJR]

oh ok, sorry about that.

I can replicate your condition in Acc 2002 by doing the following:
[tt]
1. create a form with some bound textboxes
2. set the following form properties:
Data Entry: Yes
Allow Additions: No
Filter: ((tblData.[TestField]=2))

ie the 'Filter' property contains a valid filter

3. save and close the form
4. open the form - it is now blank (ie no textboxes visible)
5. goto toolbar (or right-click) and select Records>Apply Filter/Sort
6. the textboxes are now visible.
[/tt]

Are any of the above form properties have values shown above or set in code e.g. On_load?

Cheers,
Dan

 

[fhvac]

nothing particular is set to anything, when ever i delete the form and make a new one i get the same results. Could there be a problem with the tables, or relationships?

Thanks

 

[DanJR]

I'm not sure,

Here's another guess from me...I'm also able to create the situation when a form is bound to a recordset/query which is not updatable and returns zero rows e.g.
1. the query is a snapshot and it return zero records
2. The joins within the query force the query to become non-updatable.

Is the form based/bound to a query?

Cheers,
Dan

 

[fhvac]

yes the form is based/bound to a query

 

[DanJR]

When you view the query, does it show any records and if so, can you add new records to it? Can you add/edit records within the underlying tables?

 

[fhvac]

yes it shows 1 record from 2 tables, i can add, and edit too.

 

[DanJR]

OK, I'm stumped...I can only think of trying the following

1. compact & repair
2. import the form and assoc tables into a new Access file
3. backup and try /decompile
4. send the MS Access file to some-one (or another machine) to see if they have the same prob...if that's an option. you can send it to me if you want (djrussel at hotmail.com)

does anyone have anyother/better suggestions?

Cheers,
Dan