connect to a db/table

[vttech]

I am new to VBA

I have a form that has a command button called cmdSubmit

that one click I want to connect to a Database called "NA"
stored at the following location "\\serv1\db\"

within the NA database I have a table call tblPatientLanguage
that contains two colomns "PatientID" and "Language"

I need to display the contents stored in both "PatientID" and "Language" in a msgbox

How is this possible??

Newbie in search of knowledge

 

[SkipVought]

What application are you running when you plan to access this database?

What kind of database is it that you want to access?

Please answer both questions.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[vttech]

I am using MS Access Form and the database is also MS Access

Newbie in search of knowledge

 

[SkipVought]

You might get better results in Microsoft: Access Modules (VBA Coding) Forum705 or Microsoft: Access Forms Forum702.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}