I am Having a problem getting specific record information to appear on a form that is bound to a query.
The application creates an account number for a series of tests that a specific agency is requesting. These tests may be done all at once or over a period of weeks.
I have a form that allows the user to choose an active account number. When the account number is chosen a switchboard is brought up that lists seven tests. When a test is chosen the account number information is brought forward to the selected test form.
The test form is bound to a query that has all of the products for each agency that has an active account number.
The problem is that I can’t get specific record information to appear in the fields on the form. All I get is the first record in the query.
I want to use the account number that was chosen and then enter a product number. At that point a specific record in the query should be identified and I would like the other fields in the query for that record to appear in the fields on the test form.
I have brought the account number to the test form and the first record of the query to the test form. I just can’t get the form to look at that account number and then an entered product number in the process of determining the record that appears from the query.
When I get this corrected, I will also need to add a field that will allow me to enter a reading that I am taking off another instrument, then run a calculation and write the result to another table.
If anyone could help me, thanks in advance. GGuy
The application creates an account number for a series of tests that a specific agency is requesting. These tests may be done all at once or over a period of weeks.
I have a form that allows the user to choose an active account number. When the account number is chosen a switchboard is brought up that lists seven tests. When a test is chosen the account number information is brought forward to the selected test form.
The test form is bound to a query that has all of the products for each agency that has an active account number.
The problem is that I can’t get specific record information to appear in the fields on the form. All I get is the first record in the query.
I want to use the account number that was chosen and then enter a product number. At that point a specific record in the query should be identified and I would like the other fields in the query for that record to appear in the fields on the test form.
I have brought the account number to the test form and the first record of the query to the test form. I just can’t get the form to look at that account number and then an entered product number in the process of determining the record that appears from the query.
When I get this corrected, I will also need to add a field that will allow me to enter a reading that I am taking off another instrument, then run a calculation and write the result to another table.
If anyone could help me, thanks in advance. GGuy
