assign global variable access 2002 1

[colinbell]

Hi

I have a form where the user can select a service - audit for example, and then add records, edit records etc using Audit as the service.
On the form that they select Audit I'd like to assign Audit as a global variable so when they edit/add records they can retrieve the value Audit until they return to the main menu.
The form that they choose Audit is closed once they start adding/editing and the service is selected from a list-box as me.list100.column(1)

regards
richard

 

[kramerica]

Create a module or put this line of code at the top of your module. This will create a global variable for you.

Global AuditGlobal As String

Then in the After update property on your listbox add this line of text.

auditglobal =me.list100.column(1)


Kramerica