I havve a form with a textbox that contains the record ID of a table and I want to pass that id to another textbox in another form to allow me to pull that record
I havve a form with a textbox that contains the record ID of a table and I want to pass that id to another textbox in another form to allow me to pull that record
DoCmd.OpenForm "another form name", , , "ID=" & Me.textboxname
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I've used the following in an event on a button. DoCmd.OpenForm "frm-customer / service call", , ,"CustID=" & Me.Customer_ID
custidis the name of an unbound textbox within the form"frm-customer / service call" that I use to pull up the record
Customer_IDis the name of the textbox I am getting the data from (by using a breakpoint I am able to confirm that the data is in the me.customer ID when I push the button I get an "Enter Parameter Value " under which custid is displayed and a textbox to enter a response and of course a OK or Cancel button
Is the form based on a query with a dynamic parameter? Is CustID a field in "frm-customer / service call"?
Advise no spaces nor punctuation/special characters (underscore only exception) in naming convention.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Theform"frm-customer / service call"Record source is a table called "tbl-Customer" in the form is an unbound text box named "CustID" if you key in a numeric value on key down the customer record is pulled up.
I Have a second form "frm-Service Due" it contains a field "Customer ID" I want to use the data in that field to be copied to the unbound text box named "CustID" in the form"frm-customer / service call"so when I key down the customer record is pilled up in
the form"frm-customer / service call"
Don't use KeyDown event, use AfterUpdate. Why not use combobox instead of textbox for user input of filter criteria?
Why don't you use form/subform arrangement?
Why would you copy value to an unbound textbox?
I don't understand your db structure and form design.
If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.