Insert Into Problems

[Avaldez21]

I am trying to figure out Insert Into in my form when the submit button is pressed. I have an unbound form and I can't find a way to make a bound form work. I spent minimal time creating a bound form to the table I want to send information to but I could not get the cascading combo method working. It got all the information into the table but the form was not what the boss's wanted. Is there a different way to aproach cascading combo's in a bound form? It pulls all the drawing titles instead of the title of the drawing number picked. Any suggestions greatly appreciated.

 

[namliam]

Do a search on Cascading combo's there are plenty of samples out here to help you...

 

[Avaldez21]

I have done a search and my cascading combo's are working fine in my unbound form which is what I'm planning on using. I am working on making the Insert Into command work

 

[namliam]

The trick on a bound form is to keep the cascading combo boxes unbound ... they get their data straight from queries or tables... while the form is bound to the table/query that you need to edit/append to.

 

[Avaldez21]

I got my insert into working perfectly so i'm just going to stay with the unbound form. Next time, if there is a next time, I will definitely do a bound form.