Updating Form entries to another Table

[kruger101]

Hi all

I'd be very thankful if someone can please help me with this problem.

I have 1 Table. This Table is imported and contains data from Excel. It also contains fields I added manually. There is about 20 imported fields (full of data) and about 100 manually added fields.

Then I made a Query of this table. I made some calculations in this Query.

I then created a Form based on the Query. I then made a Combo Box. This Combo Box selects a customer, and then updates the other fields (the ones I imported from Excel) depending on the customer I selected.

So now what I want to do is this: I want the fields (updated from the query) and newly entered data to save to another newly-created table. Can someone please help me with this? Any ideas?

Thanks a lot. All input greatly appreciated.

kruger101

 

[Banana]

Sounds like you might want your form to be unbound, meaning more work in setting everything's control source but more flexibility in recordsource.

 

[kruger101]

OK maybe I was trying to give too much info...

How can I use the "OutputTo" Macro-Action to only save 1 record? And in this record I want to also save some objects that has an "unbound" Control Source property?

Any ideas? Thanks a lot guys. I'm pretty numbstruck by this one. If I'm too unclear please say - It's difficult for me to explain my problem.

kruger101