calling different forms from one unique form (1 Viewer)

[sigmar]

I have an access 97 database with several tables, and I want to go to one of the tables depending on what the user types in a form. It can't so difficult so, how can I do it?

 

[D-Fresh]

Well, I'm not too sure what you mean by that but if you just want to open different tables based on different responses then you should use a select case statement...

Select Case me!FieldName
Case "Response1":
'Use Table1
Case "Response2";
'Use Table2
.
.
.
End Select

Hope that helps... If not, could you give a little more detail as to what you are looking to do..

Doug

 

[sigmar]

Thank you D-Fresh,

I finally got it, and your code was almost what I needed. I know my explanation was not good, but that's because my English is not good enough.

sigmar