Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tab form to go to specific record

Status
Not open for further replies.
jcpelejo

jcpelejo

Programmer
Jul 29, 2001
70
US
Hello. I was wondering if there is a way to point my query results to a specific record in a table. I currently have as a reference point "ClaimNumber". On one of my tabs, I have a query form that displays query results based on the criteria entered into one or several text boxes. The results are displayed in a subform called "Search Query Subform". I would like to double click on a text box in subform therefore synchronizing the information on the other tabs to be associated with the information that was clicked on. The tab form currently references all information by "ClaimNumber".

Main Form: [Manual Claims System - MR Canada]
Subform: [Search Query Subform]
Textboxes in subform: [ClaimNumber], [AgreementNumber], [LastName], [FirstName]

Please advise.
 
Status
Not open for further replies.

Similar threads

I
  • Question
How to get 2 codes to work together.
Replies
6
Views
307
hermanlaksko
hermanlaksko
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
340
renigar
renigar
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
514
Kennelbloke
Kennelbloke
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
622
dhookom
dhookom
MattGreer
  • Locked
  • Question
Add Field Description to a Form 2
Replies
5
Views
254
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top