Macros opening Data Entry Forms and copying Data.

[TedMurphy]

Hi!

Ted here, I need some help with a form and some macros.

Here is what I have I have a data entry form (frmNewOrder)where I enter the customerID then I go to a combo box which says Air Freight or Sea Freight what I would like to do is that when Air Freight is selected have the Air Freight Data Entry form open (frmAirFreightordr) and then copy the customerID to the field that says CustomerID in the Air Freight, and Sea Freight is selected then it opens the Sea Freight Form (frmSeaFreightOrdr) and copies the CustomerID that I input to the CargoDetails into the customerID field (which is related in both forms)

Could you please help me with this? I would greatly appreciate some help thanks,

Ted!

 

[Rich]

That would tend to suggest you're entering data into two separate tables, is that correct? If so you probably only need one, post some details

 

[TedMurphy]

Sorry I can't have one big form

This is because there are three seperate tables

one for Cargo Details

one for Sea Freight and

one for Air Freight

as one order for cargo can only be sent through one means of transport (Ie Spare parts for a refigerator can only go go either by shipping or plane)

One the Cargo Form first of all on that form I input the CustomerID

Then what I want to happen from the drop down menu when I select the the attribute Sea Freight the form for Sea Freight Details will popup and the same would happen when I select the Air Freight just the Air Freight Form would pop up.

When either of these forms pops up I want it to have the CustomerID from the Cargo Form to copied onto whichever form pops up (Sea Freight or Air Freight)'s CustomerID field.

 

[Rich]

The point I was trying to make was that you only need one table for freight, and a field within it that identifies if it's by sea or air, that way you can have as many freight methods as you like without having to create more tables

 

[TedMurphy]

I can see what you are talking about however my Sea Freight and Airport tables have different attributes for example my Air Freight table has Airport of Discharge and Airport of Recevial while the Sea Freight table has port of discharge and and port of receival and I need them to be seperate tables for the queries (which I'll be bugging you for help with soon *LOL*)

Thanks for the feedback and time to answer my question though mate, you probably know best.
Ted,