Subform (Access 2K)

Topic

New Reply

I have a form frmHouseHold and a subform sfrmApplicants in Access 2000. I created two Find Record buttons one for the main form and another one inside the Subform. The main one works fine, but the one inside the subform doesn’t. Could you please tell me how to fix this?

Thanks,

DD

Reply | Quote

Replies

How did you create the find buttons, and what kind a failure are you getting on the subform? The subform should only display the Applicants that belong to a give Household, so is presumably a small number of records. Does your subform display records in a data grid or a continuous form, or is it a single form display?

Reply | Quote

Hi
Thank you for your reply post.

I created the Find Record button by using the wizard. The error message i was getting:
‘Microsoft access finished searching the records. The search item was not found.’

It’s true that the subform only displays the applicants that belong to a given Household, and are small number of records. I’m not sure when you ask if my subform displays records in a data grid or continuous form…
The way I have it set up is when you open the data entry form from the switchboard, you’ll see the form on top along with the subform at the bottom & you must first enter household before you enter Applicants. So I assume is it a continuous form?

Hope this clarifies!

Thanks,
DD

Reply | Quote

That isn’t an error message, it’s a statement of fact. Whatever you were searching for wasn’t found. In order to help, we need more information about what you were trying to search and what controls are on your subform. The search is through the recordset of the subform, so it doesn’t matter whether it’s continuous or not.

Reply | Quote

My fields in the subform are: AppID, AppFirstName, AppLastName, AppStatus etc. and I was trying to click for instance, in the Last Name or First Name field and use the Find Record button to be able to search for the name.

Thanks,

DD

Reply | Quote

Make sure the wizard code is setting the focus back to the subform control before it starts its search. Otherwise, it will not know what to search for.

Reply | Quote

Make sure the wizard code is setting the focus back to the subform control before it starts its search. Otherwise, it will not know what to search for.

Reply | Quote

My fields in the subform are: AppID, AppFirstName, AppLastName, AppStatus etc. and I was trying to click for instance, in the Last Name or First Name field and use the Find Record button to be able to search for the name.

Thanks,

DD

Reply | Quote

That isn’t an error message, it’s a statement of fact. Whatever you were searching for wasn’t found. In order to help, we need more information about what you were trying to search and what controls are on your subform. The search is through the recordset of the subform, so it doesn’t matter whether it’s continuous or not.

Reply | Quote

Hi
Thank you for your reply post.

I created the Find Record button by using the wizard. The error message i was getting:
‘Microsoft access finished searching the records. The search item was not found.’

It’s true that the subform only displays the applicants that belong to a given Household, and are small number of records. I’m not sure when you ask if my subform displays records in a data grid or continuous form…
The way I have it set up is when you open the data entry form from the switchboard, you’ll see the form on top along with the subform at the bottom & you must first enter household before you enter Applicants. So I assume is it a continuous form?

Hope this clarifies!

Thanks,
DD

Reply | Quote

How did you create the find buttons, and what kind a failure are you getting on the subform? The subform should only display the Applicants that belong to a give Household, so is presumably a small number of records. Does your subform display records in a data grid or a continuous form, or is it a single form display?

Reply | Quote