Getting the information from a Combo Box and show a information

  • Thread starter Thread starter Rodrigo Borges
  • Start date Start date
R

Rodrigo Borges

I have a table with 2 fields:

server
vss

Now I need to create a form that show me the vss based on the server
selected (a server can have more than one VSS). I added a combo box on Form
Header showing the field server. Now I need to create a event (After Update)
to show me the VSS relationed to the selected server on Form Detail. I want
to show as a spreadsheet.

Does anybody know how do I accomplish this task?
 
You are going about this wrong. You need the following tables:
TblServer
ServerID
<<Other fields about Server>>

TblVSS
VSSID
<<Other fields about VSS>>

TblServerVSS
ServerVSSID
ServerID
VSSID

Create a form/subform where the main form is based on TblServer and the
subform is based on a query joining TblVSS and TblDerverVSS. The subform
will now display a list of all the VSS associated with the Server in the
main form.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Back
Top