List Box or Combo Box?

  • Thread starter Thread starter Anthony W
  • Start date Start date
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.
 
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
 
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




.
Click to expand...
 
Back
Top