Create a client directory

Hi,
I am new to the VB language and i am currently developing a IS for a client,
i would like to save the database using a command button "cmdCreate"
and i would like to open the save as dialog (which is easy) but i would like it to automatically
generate the file name by reading the following labels txtfirst, txtfirst, txtBusinessName and txtClientNumber.

Thanks.

1) Are you doing this in Access?

2) Why do you want a Save As dialog if you're going to have it automatically create the name? Is it an option for them to override the auto name?

Yes i am using access, well thinning about it, it doesn't need to bring a save as dialog as long as its able to generate the name from the labels, any suggestions?

Quote:

---

as long as its able to generate the name from the labels

---

this is simple to do, what part are you having a problem with?

Code:

---

savename  = fullpath & "\" & txtfirst & txtlast & txtbusinessname & txtclientnumber & ".mdb"

---

change file extension to suit, i did not duplicate txtfirst as i assumed it was a typo