List Box or Combo Box?

A

Anthony W

My main form has details on a student, such as name,
address, etc. On my form i have a button that when
clicked opens another form that stores information on the
students' schemes.

The scheme form is linked to the main form using a VB
code. On my scheme form i would like a list of the
schemes for that particular student, so when i choose what
record i want to see, it will be shown.

Do i need a list box, combo box or something else? I have
tried using a list box, but when i added it to my form it
showed all schemes within the table and did not relate it
to the learner, so i have obviously done something wrong.

This is new to me, so simple instructions would be greatly
appreciated.

Thanks in Advance


Anthony W.
 
S

Sam

Sounds like a combo box might be the go. You'll need to set its Control
Source so it only shows the current student's schemes.

Its difficult to detail the SQL for the control source without knowing the
design of your DB.

HTH
Sam
 
A

Anthony W.

Thanks Sam,

Bit of a nightmare.

-----Original Message-----
Sounds like a combo box might be the go. You'll need to set its Control
Source so it only shows the current student's schemes.

Its difficult to detail the SQL for the control source without knowing the
design of your DB.

HTH
Sam




.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top