passing data from 1 continous form to another continous form

[sdel_nevo]

Hi Guys



I am stuck with the following problem

I have 2 forms both set as continuous, "form A" is a list of machines and locations, "form B" is a continuous form that holds customer data.

on "form B" there is a combo box that holds the machine names

is it possible to pass the first three machine names from "Form A" into the "Form B" machine name, I was thinking that I could change the combo box on "Form B" to a text box but I am completely stumped as to pass the required data.

any help would be great

Many Thanks

Steve

[ItsMe]

Data is stored in tables. If a specific field, from within a table, is visible in form A it can be visible in form B, also. So, you do not need to "move" the data. You need to adjust the form's or combox's recordset.

Perhaps adjusting the form's Filter property or a combox's WHERE criteria is the solution.

[sdel_nevo]

Hi Itsme

thanks for the reply, that sounds like a plan I will give that a go, many thanks for the heads up

Steve