Forms help

C

chantalbertrand1

I have created a form in Access Design View that links to a couple of
tables; however, when I look at it in form view, it appears to be
blank. Can someone tell me why this may be happening?
 
B

Brendan Reynolds

Do you mean blank as in text boxes etc. are empty, or blank as in text boxes
etc. are not visible at all?

If the latter, this happens when the form's recordset returns no records,
and the AllowAdditions property is set to 'No'.
 
R

Rick B

Do a search. This is asked and answered all the time.

Your data set is not updateable, and you have the form set to not allow
additions.
 
S

Sprinks

By "links to a couple of tables", I presume you mean the form's RecordSource
property is set to a query containing the two tables. If this is the case:

- Run the query itself to see if it is returning any records.
- Check the form's Data Entry property. If it is set to Yes, the form will
display no existing records.

Sprinks
 
C

chantalbertrand1

I have set the Allow additions to "Yes", however, the form continues to
be blank. The entire form is blank. I cannot see any of the text
booxes or labels I have created.
 
R

Rick B

Is the query updateable? If you open the query can you add a record?

Are there any records in your query. If you open the query, do you see any
existing records?

"allow additions" was only ONE of the issues.
 
C

chantalbertrand1

It's not a query, it's a form. I haven't yet created the query. I
also have no data in the tables yet. I am creating a form for other
users to input the data.
 
R

Rick B

Okay, a form is normally based on a query. What is the record source for
this form? Are you basing it directly on a table? Typically, you would not
do this. In most cases, you'd filter the data down in a query first.

If your form is only based on a table, then make sure the form allows
additions. Also, make sure the user who is signed on can insert data into
that table.

If all else fails, just go add a record in the table to get the ball
rolling, then try to open your form.
 
R

Rick B

Ummmm. You said it links to "a couple of tables". How'd you pull that off
if you are not using a query as your record source?
 
C

chantalbertrand1

I guess I may have gone about this a little backwards, I am trying to
create a form that allows data entry into the table, without having to
use the actual table. THis is so that the employees entering the
information will not be able to move to the next field without filling
in each required field. Right now the table is empty, as I am not the
one that holds the required information.
 
R

Rick B

Requiring the employee to make entries as they move from control to control
has nothing to do with whether or not your form is bound to a table.

That would be accomplished by using code in your control's exit events or
enter events. Probably a bad idea unless you really want to force them to
enter data in exactly the order you require. (In my opinion)

Unless you are a very advanced Access developer, step back and start from
the beginning. You are trying to build an aircraft carrier when you've
never even build a dinghy. :)

Build a form based on your table (or a query). If you require the data in a
particular field, set it as required in your table. Once you do this, and
use it a time or two, then you can start tweaking the form.

(In my opinion)
 
C

chantalbertrand1

That is great advise. I will surely use it. I am still at a loss in
reference to my first question though; and that is, why is my form
blank when I go from Design View to Form view. I have changed my Allow
deletion field to "Yes", and still nothing. I have tried deleting the
form and creating a new one, and still, my Form view remains blank. I
have also, after reading your previous answer, tried to create a query
(although I do not yet have any information in my tables to pull) and
then creating the form from the query. Yet, the form remains
completely blank in Form view. What am I missing?
 
R

Rick B

What is the data source of your form? Is it bound to a table?

You said you allowed "deletions". That is not important. Can you ADD data?

If the form is based on a table, can the user add records to that table?
 
Top