Importing in default data from form

[themanof83]

Hi guys,

Here is the problem. I have a master table which includes every record of that sort in it. Wot I would like to do is have the user enter specific information into fields via a form, then select an option from a combo box which selects a default table (depending on the selection) containing x amount of records and then have the information passed from the form into the relative fields in the records in the table.

Finally I would like all the records from the 'created' table to be added to the master table. I hope I have explained this well enough!

Thanx in advance.

Ash

 

[themanof83]

Thanks Pat. Could you provide me with a short example of how you would do that?

 

[themanof83]

Awesome, nice little feature that!

Cheers Pat

 

[themanof83]

Ok back to this little chesnut!

I have the Append query working perfectly but it only seems to want to add the same number of records that are already present in the designation table.....

How can I avoid this since tblA and tblB do not have the same number of records??