form/subform issue

[Bill Moore]

I'm trying to do the following:

1. Create a main form with a single text box that will contain a complete or partial name of a client. There is also a command button that fires a query to select records matching the text box value.

2. I would like the returned records to display in a subform below the main form and not in the standard query return format. This really isn't the standard form/subform style where a one-to-many relationship exists between 2 tables but rather a one-to-many relationship between a single client name and the possible multiple entries for that client from a single table.

Would appreciate help on how to do this.

 

[MStef]

Hello Bill!
You don't need a MainForm and a Subform,
you don't need a Command button.
Look at "DemoClientA2000.mdb", I think it can help you.

 

[Bill Moore]

Thanks

Thank you very much. I get the idea and will revise my app accordingly.

Bill Moore

 

[Bill Moore]

almost working

I have one additional problem.

When I run the form and make a selection from the combo box, if that selection results in say 4 records, my detail section doesn't expand to show all 4 records. The record selector at the bottom of the form indicates that I have 4 but I only see one at a time.

I must need to set a form property or something but I don't know what at this point.

A little more help would be appreciated.

Thx.

 

[MStef]

In properties "Default View" put CONTINUOS FORM.

 

[Bill Moore]

Default View

I did. Just checked and the Default View property of the form is 'Continuous Forms".

Still, only the 1st record is listed.

Thx.

 

[MStef]

Ok, enlarge your form.

 

[Bill Moore]

No luck

I enlarged the detail section of the form, at least enough to hold 20 records or so, but no luck. Still just one record displayed. My test case should display 4 records. Record selector at bottom says 1 of 4 but only the first is displayed in the detail area.

Any more ideas?

Thx.

 

[Bill Moore]

Hoooray!!

I got it to work but not sure why. On the form, I resized the detail area to about the size of 1 record. Suddenly, it worked.

Strange, but thanks.