Passing value to Form

[Guest]

I developed a dbase using Access that keeps records of incoming vessels. I
have multiple tables. The main form that I have a question was created from
the tblVessels. I also have a table (tblviolations). This table have the name
of vessels that have been issued a violation. One of the field (ViolType)
stores the type of violation issued. On the form I have a field, ViolType.
You probably guessed by now, I need the ViolType on the Form to be populated
with the value of the tblviolations.ViolType everytime a vessel name is
entered on the Form and matches the name on the tblviolations.
I tryed the Lookup vba code but could not get it to work.

Thanks, Wilfredo

 

[Albert D.Kallal]

If the vessels form is going to be "open" when are entering data in the
volitions form, then you can set the "default" of the control for ViolType
to that of the vessels form field


forms!Vessells!ViolType

The above should work as the default.