Blank Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that is based off of a table and a subform that has list boxes
of month and year. The information on the subform is saved to a table with a
relationship to the table that has the saved information for the form. I can
choose info in the subform but when I reopen it is blank. It is saved to the
table but I would like it to show up each time the subform is opened. Please
help.
 
I have a form that is based off of a table and a subform that has list boxes
of month and year. The information on the subform is saved to a table with a
relationship to the table that has the saved information for the form. I can
choose info in the subform but when I reopen it is blank. It is saved to the
table but I would like it to show up each time the subform is opened. Please
help.
Click to expand...

Check to be sure that you have the subform's Data Entry property set to No;
the Data Entry property of a form only lets you enter new data, not display
existing data.

If Data Entry is set to No, post back with the Recordsource of the subform.


John W. Vinson [MVP]
 
The data entry is set to no. Here is the record source:


SELECT Subform.Advertiser, Subform.Month, Subform.Year FROM Subform;
 
The data entry is set to no. Here is the record source:


SELECT Subform.Advertiser, Subform.Month, Subform.Year FROM Subform;
Click to expand...

Is your *TABLE* named Subform!? That's a very odd name for a table, and may be
a reserved word. If you open this as a Query do you see data?

John W. Vinson [MVP]
 
Yes, the table name is Subform and I do see info when I open it as a query.
I will rename the table and see what happens.
 
I renamed the table and still does not work. When I open the subform there
is nothing displaying. I set all three items in my subform as primary keys
so they cannot be duplicated but this does not help with them automatically
showing.
 
I renamed the table and still does not work. When I open the subform there
is nothing displaying. I set all three items in my subform as primary keys
so they cannot be duplicated but this does not help with them automatically
showing.
Click to expand...

That is VERY VERY peculiar. Month and Year are reserved words too - but that
should cause *other* problems not this one.

Please post the following properties:

The Form's Recordsource
The SQL view of the query, if the recordsource is a query
The new name of your table
The fieldnames and datatypes of the fields in the table
The Control Source properties of the textboxes on the form
The Data Entry property of the form (should be No!)

John W. Vinson [MVP]
 
The data entry property box is set to no.

SELECT Operators.Competency, Operators.[Date Passed], Operators.[QTO Name], Operators.[QTO Number] FROM Operators;

Ultimatly the one of the field column contents of the subform will, hopefully, fill in a competency box on a licence that, again hopefully, i can get it to produce automatically.
 
Dont know why I post the above post one here, Sorry all. Thought was a reply to my query
 
Back
Top