[AccessD] Passing a form byval

Hi Gustav
 
Many thanks. Was the last bit I missed. Just thinking I sent that email on the 10th of Sept???
 
 
Martin
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of Gustav Brock
Sent: Fri 22/09/2006 11:19
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Passing a form byval



Hi Martin

It works here:

Public Function SetTextbox(ByRef txt As TextBox)

  Debug.Print txt.Value
  txt.value = "33"
  Debug.Print txt.Value

End Function

Now, call it like this:

? SetTextbox(Forms.Item(0)!txtYourTextbox)

/gustav

>>> mwp.reid at qub.ac.uk 10-09-2006 21:50:00 >>>
I need to pass a text control on a form to a procedure byval as opposed to byref as byref errors out. How can I pass this to the procedure byval?

Martin

Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>