Can I use vb to open a form then select a value in a combobox please?

[steveroot]

Hi all,

I am writing a new invoice database for my small business. Customers are held in a seperate table to the invoices. When a new customer is added, i want a button to close the 'addcustomer' form, open the 'invoice' form (that bits been easy) but then..
***
Select the customer that has just been added from a combo box on the invoice form.
***
The combobox is bound to the customerID, and i have the new customers id held in visual basic code from before i closed the 'addcustomer' form. I also want the same thing to happen when we want to invoice an existing customer, ie have a form to lookup customers, select the one we want, then open a new invoice with that customer automatically selected.

If anyone can help it would be greatly appreciated.
Regards,
Steve Root

http://www.roots.eu.com

 

[WaltLukeIII]

I have found that the easiest way to do what you want is the use of Global Variables. You Make a new Module and in the General Section of the Module declare your variable and type

i.e.

Public CustId as long
Public Custname as string

Then you simply have to set the variable in one form or module and then just use it like you would any other variable.

Walt III
SAElukewl@netscape.net

http://www.muc.edu/~lukewl

 

[steveroot]

Thanks Walt, but i dont quite understand.

I still dont know how to select the customer from the combobox. Because I probably didnt explain it very well, i've uploaded the database to my website (msaccess 95) as I'm sure seeing the problem first hand will make it easier for me to be understood.

http://www.rootskitchens.co.uk/family/steve_root/index.htm

or

http://www.rootskitchens.co.uk/family/steve_root/rootiesinvoice.mdb

(MS Access 95 - 270Kb)
or

http://www.rootskitchens.co.uk/family/steve_root/rootiesinvoice.zip

(zipped version of above - 52Kb)