It seems to me you would need to link the tables together by adding an
"EmployeeID" field to the TRAVEL table. Then create a subform on your form
for the Travel information, linked by the Travel.EmployeeID to Employee.ID
(this is set in the properties of the form and subform).
To automatically go to the Employee's record, put the following in the
AfterUpdate Event of the TextBox or ComboBox that you are typing the ID
number into.
Me.RecordsetClone.FindFirst "[ID] = " & Me!TextOrComboBoxName
Me.Bookmark = Me.RecordsetClone.Bookmark
Then you will need to either click for a new record on the travel subform or
do it automatically in VBA code.
Hope that helps,
Toby
----- Original Message -----
From: "masuma_tumpa" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, September 22, 2005 3:32 AM
Subject: [AccessDevelopers] Auto Data Entry in a from
> Can any one help me.
>
> Say I have two tables. one is EMPLOYEE and another is TRAVEL. and
> the fields are like below:
> EMPLOYEE
> ID
> Name
> Conteact_Date
> Work_Location
> Supervisor
>
> and
>
> TRAVEL
> ID
> Destination
> Departure_Date
> Return_Date
> Price
> Invoice_No
>
> Now I want to make an entry form to enter the travel information of
> each travel where the both tables relative record will be display.
> when I enter the ID then from the master employee table's record
> will be automatically display and tehn I will enter only the travel
> data information. I try to do it but the form's record was read only.
>
> Thanks in advance for helping.
>
> Masuma.
>
>
>
>
>
>
> Please zip all files prior to uploading to Files section.
> Yahoo! Groups Links
>
>
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
