Help with VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a two tables one for student data and one for test data. As of right
now these two are totally seperate. In fact when a student comes in for a
test we are typing in all of their test information in a form. Well all the
data is already sitting right there in the test tbl. Anyway. what I would
like to do is if two certain feilds the student would input in then these two
other certain feilds automatically have the data needed. Example.
Professor: Thomas, Test: Test 1 then using that info the next two feilds are
retrieved from the test tbl from the same record Allowed Time:60, Mail : C205

I hope this makes sense.

Thank You
David
 
David,
It almost makes sense 8-)
You say the tables are totally separate. Does that mean they are in
separate databases or are they in the same database but unrelated?
What type of user are you? Are you a "Power user" that can write macros, a
"Programmer" that can handle VBA Code; an "Entry Level" user just learning
Access?
Which version of Access are you using?
Beyond that your question makes sense and what you want to do can be done.
There are several ways to answer your question depending on what kind of
user you are.
Jim
 
Jim,

The two tables are in the same database and unrelated. I'm a Entry level
programer. Basically I'm trying to learn Vba on my own and with help from
the groups. I'm using 2003

Thank you for the reply

Dave.
 
Since there are only two fields involved, I'd suggest the Dlookup() function
to get the additional data. You will need a separate Dlookup() for each
field. Code them in the AfterUpdate event for the last field where the
lookup parameters are entered. Assign the returned value to the form field
where they are to be displayed. You can get the syntax for Dlookup by
typing that name in the help index field. It is not documented in the VBA
Language reference section of help.
Hope this helps
Jim
 
Back
Top