Thank you for your response. I have corrected the code, but now when I try to enter an Account # that I know is in the Accounts table, I get:
Data type mismatch in criteria expression. (Error 3464)
From Help:
The criteria expression in a Find method is attempting to compare a field with a value whose data type does not match the field’s data type.
Could you provide a bit more guidance?
...
rgdwar1
Last Activity: Oct 9 '06, 10:28 PM
Joined: Sep 27 '06
Location:
-
Code help to pull value from a table based on input on form
I need some of your expertise here.
I have a form frmEnterBill. On this form I have an Account# text box and a CompanyName text box (as well as some others). I have a table: Accounts with Account # and CompanyName. I have code in the AfterUpdate event of the Account# field in the form to populate the CompanyName textbox on the same form by pulling CompanyName from the Accounts table that matches the AccountNumber entered in the form.... -
How to populate fields based on the results of another field?
Hi,
I am a newbie at this so please forgive my ignorance.
What I have is an Accounts Table with Account #, Company Name, and logistic info (Address, Phone). I have a few forms that I want to program in such a way that when user enters an Account # on the form, after update I want the Company information to feed from the Accounts Table into the field on the form. Please give me some idea how to do this? Or a step in the... -
Can anyone help???...Leave a comment:
-
No records showing when on form
Hello, I have two issues I need help with:
I have a Data Entry form called Frm_Entry (with a corresponding table) with the following fields:
Date Assigned (Date)
Date Processed (Date)
Date Submitted (Date)
MS-Company (Text)
Client (Text)
Reimbursement Amount
Submission Amount
Total Payout (Auto sums)
Paid (Yes/No) that if checked enables the visibility of the "Date...
No activity results to display
Leave a comment: