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    
post Sep 19 2019, 03:56 PM

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!

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

Posts: 888
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    22nd October 2019 - 03:31 AM