UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Perform A Lookup On A Form, Access 2016    
 
   
jbtyler
post Sep 19 2019, 03:56 PM
Post#1



Posts: 4
Joined: 2-August 19



Hi everyone,

I need some help. I'm trying to do a lookup against a table from a form. My goal is when a user enters the "Enrollee Jag Number" it performs a lookup in a table named "Faculty_Info" for the "LastName" of the individual with that Jag # and places it in a textbox on the form. I have created a textbox but cannot get the syntax right. My ultimate goal is to have it do a lookup for both the "FirstName" and "LastName" to ensure that the users are typing in the right number. I have attached a copy of the form for your reference.

Thanks in advance!

--Ben
Attached File(s)
Attached File  Form_lookup_squence.JPG ( 253.53K )Number of downloads: 8
 
Go to the top of the page
 
June7
post Sep 19 2019, 04:06 PM
Post#2



Posts: 867
Joined: 25-January 16



Consider this approach http://www.baldyweb.com/Autofill.htm

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    14th October 2019 - 11:24 PM