More search questions

[RuralGuy]

The 1st form opens the second form in Dialog mode which stops the code in the 1st form at the OpenForm line. We also pass the name of the 1st form so the 2nd form can decide whether to close or just go invisible when you push the Command Button. just selecting a record on a Continuous form make that record the Current record. You didn't have the [ID] field displayed on the second form so I created a control for it [txtID] and hid it under one of your displayed controls. When the code get back to the 1st form we just do a .FindFirst on the [txtID] value from the 2nd form and then close the 2nd form moving the 1st form RecordSet to the correct record.

[jakeao]

Ok, I think I get it. Thanks again for all the help.

[RuralGuy]

You're very welcome. There are other ways to do this. I just showed one of them.

[taylorosso]

hi,

can this '2 step search' be done by firstly populating a list box. then from the results you select in your list box, opens up a record on your main form?

Please see attachment for a diagram of what i mean.

I am using access 2003, was unable to open your demo of the working search.

cheers

[RuralGuy]

The simple answer to your question is Yes. The sample did not lend itself to convert to ac2K easily. If you want to put together a sample of what you want, I will be glad to assist in getting it to work properly.

[taylorosso]

ok thankyou, what would you need by way of a sample?

constructed forms?

[RuralGuy]

Yes, constructed forms where you tried to accomplich what you want.

[taylorosso]

here is my sample,

nice and simple, 3 forms, 1 table.

The actual problem is trying to get the list box to populate properly based on the first search entry.

[RuralGuy]

This should move your project along a bit.

[taylorosso]

thats great! thanks very much. What did you do as I now have to integrate that into my main project?

[RuralGuy]

Look at the OnLoad event of the ListBox form.

[taylorosso]

i see it. Thanks again!

[RuralGuy]

It is just one way to do it. I'll bet there are at least 3 other ways to do it.