IF I HAVE A ONE TO MANY TABLE DOES MY INPUT FORM HAVE TO HAVE A SUBBOX



MAIN TABLE --- DATE TABLE



ONE PROJECT --- MANY DATES



INPUT FORM MUST SHOW THE PROJECT INFO-BUT ALSO BE ABLE TO INPUT THE MANY 

VARIOUS DATES

I have a quick question, does anyone know how to add new data into an 

input form, which is run by a query of several tables.



I would like to have a delay between entering the information and pushing 

it into the data base, thus, having an edit button, or save button to push 

the final part. This will stop have entries into the database.

1) My input form will not allow me to enter infromation on a new clean 

form_Why?

(Last record #860- I can not pass this number)



2) I would like to enter information on a new clean form and then push it 

into the database after reviewing it. I would like to use a 

save,update,delete, button- thus not changing information in db while 

typing it in.



Help

(or send Code)

Kenneth

 1) My input form will not allow me to view a clean input form so that I 

can add new information into my database, what is the problem?

2) My form automatially inputs information into the database before I have

 had a chance to check it, How do I review the information then hit the 

update or add button to push information into the database.



 

Please help?(or send Code)

Kenneth,



Send me your database in zip format and I'll see what we can do







John Ruff - The Eternal Optimist :-) 



papparuff@c...

Kenneth,



Look at your form properties and see if "Allow Additions" is set to No.  It

may explain you not being able to add records.



vlad