Binding fields in a table

[Lynnjm]

I have a table called Project Hours with fields. Two of the fields are Project No and Project name.

The main table is called Project Budget where I also have Project No and Project Name.

Is it possible, when I am in the Project Hours table that when I type in the Project No and then tab to the Project Name field it will automatically select the associated Project Name.

Thank you

 

[Mile-O]

I have a table called Project Hours with fields. Two of the fields are Project No and Project name.

The main table is called Project Budget where I also have Project No and Project Name.

You shouldn't have these fields in both tables.
I'd say you should have one table called tblProjects.

I'd advise you to do a little reading on normalization and the normal forms.

 

[Lynnjm]

These two tables are linked and I have to have the Project Budget with all the project details. It is a one to many table - so it works just fine.

 

[Mile-O]

If they were linked properly then you wouldn't have the same two fields in different tables. The one field that relates to the one field in the other table (as a primary and foreign key respectively) are sufficient to allow the extraction of the extra fields required through the use of a query.

 

[Kevin_S]

Are project number and project name part of a composite key? you shouldn't store the same data in both tables if they are not as you could/will run into problems down the road...I'd create a structure with a projects table (tblProjects) that hold project name, number etc... then have another table (tblProjectBudget perhaps) with a many to one realtionship with the tblProjects table as projects can/usually will have more then one funding source... just ny 2 cents though...

As far as your question: Yes its possible. if its the same form you can use the recordsetclone property like such:

Me.RecordsetClone.FindFirst "[ProjectNo] = " & Me.txtfindbox
Me.Bookmark = Me.RecordsetClone.Bookmark

I would suggest following Mile's suggestion though and reading more on Normalization starting here first...

HTH,
Kev