ms access - passing parameter Between forms (2 forms) -
ms access - passing parameter Between forms (2 forms) -
i have 2 forms (form1,form2)
when pass parameter form1 form2 pass id not value
code in form1
docmd.openform "form2", acnormal, , , , acwindownormal, me.combo5.value code in form2 (load event)
me.text0 = (me.openargs) combo5 id retrieve other values table(id , username, password)
how can retrieve username?
if datasource combobox has 3 fields of table can access via column property http://msdn.microsoft.com/en-us/library/office/ff192660(v=office.15).aspx
me!combo5.column(1) otherwise have dlookup() http://msdn.microsoft.com/en-us/library/office/bb148913(v=office.12).aspx
ms-access access-vba
Comments
Post a Comment