Multiple Records pulled up at once

[ArcherSteve]

First, I apologize if this has been answered before. I've tried searching for it and came up empty.

Is there any way to bring up more than one record in a "Columnar" Form? i'm using this database for an archery tournament and what I need is to enter the target number into a search function in the header and call up the 3 or 4 archers on that target to enter "running" scores. Any ideas? If this can't be done in a "columnar" form, is there any other way?


Thank you guys in advance. If anyone knows the answer, it's you guys.

Steve


PS If someone knows of a thread that answers my question, please post the link. Thanks!

 

[cardgunner]

If you go to design view and open the properties of that form you can select the default view to be single form or continouus forms or datasheet. However if the body of your form takes up the most of the screen it will look like a single record. Look for the scroll bars on the right. Hope it helps.

By the way to get to the properties of the form you have to have to have the form in design view. Click once in the upper right corner where the two rulers meet to make a dot in the box. then right click. Hope it helps.

 

[ArcherSteve]

That kinda works. I was hoping for something like I search for target #11 (i got the search function working) and the four archers on target 11 pop up and no others. The main reason I want to do this is because the database will be shared and I don't want both computers accessing all the records at once. (Computer 1 will do targets x through y and computer 2 will do targets y through z (not including y) to prevent data override conflicts.)

 

[boblarson]

What you want is to change the recordset of the form to include only those that you want to look for.

To do that, you could have a combo box to select which target you wish to show data for and then have as the recordsource of the form a query that has that combo box as the criteria. Then, on the afterupdate and/or change event of the combo box requery your form.

 

[ArcherSteve]

so basically just set the criteria of the query to the value of the combo box? can this be done with an unbound field instead? Would that have to be in the body or the header or does that not matter? and then make an event to requery....



EDIT:
That worked perfectly! Thank you so much! I really appreciate it!