Form woes

[Cat]

I have built the necessary tables, created a query, and created a beautiful form from the query.

The Form will display the existing records in the table but I don't have the option on the Form to add new records. What dumb thing have I done?

Is it better to build the form directly from the tables?

Thanks for helping

 

[jfgambit]

Cat:

If the form is for data entry then have it's records source be the table. If you are doing any caluculations in the query, you can add them to the form via unbound textboxes and code.

HTH

 

[ghudson]

You need to ensure the "Allow Additions" form property is set to Yes.

HTH

 

[Cat]

The allow additions form property is set to allow additions.

The record source would be more than one table, so would the best course be to go back and create a form using the records from each table need in the form?

Thanks again.

 

[jfgambit]

Um Cat....

Are you saying that there is no button to add a new record or that you can't use the navigation button to move to a new record?

 

[Cat]

The Add More Records navigation button is greyed out. All it will let me do is view the existing records in the table.

 

[jfgambit]

Can you post a zipped version of the database?

It might have something to do with your joins in the query.

 

[Cat]

The file is to large to attache even after I zipped it.

I'll keep working away at it.

Thanks.

 

[jfgambit]

Run a compact on the database and then zip it. If it is under 10 mb I have an additional account I can have you send it to, if you still want me to look at it.

 

[Cat]

Thanks. I would really appreciate the assistance. I think it must be the relationships but I am not seeing what I have done wrong.

Even after Compacting and putting into zip format it is 39KB.

 

[jfgambit]

Cat;
From what I saw, the database joins were incorrect. I made some changes. See if this works better for you.

Also I changed the name of the special instruction table (it was kind of long). You want to try and avoid using special characters (* - $ !, etc) in names. It can make coding a problem in some cases.

HTH