Reposting the question about search form

bkalimili

Registered User.
Local time
Today, 08:40
Joined
Aug 23, 2004
Messages
23
Hi,

I have a main form, frmmain, and subform accdetails subform.
The main form has a unique record combination of 3 fields.
1)Business unit, 2) GL Journal ID 3) Journal Date.
Right now for every record the business unit is same,

Only the combination of GL Journal ID and Journal Date are Unique,

That means there might be many records with either GL Jouranl ID same of Journal Date being the same.

For each record on the main form, there are several Journal detail entries in the subform.

I am trying to create a search form, so that the user enters a GL journal ID or Journal date through a option button selection in text box.
Depending on which, it should give all the records matching the Gl journal ID or Journal Date with its records in subform.

I have written some code, it is taking me know where, giving errors. I am trying it since yesterday but no success.

Can any expert please guide me, how should I acheive my task.

Thanks in advancce
 

Users who are viewing this thread

Back
Top Bottom