Prefilled fields preventing filter from working?

[Stacey]

Hello.

I have a form, FrmPlanAdminStatus, that has a button to open another form, FrmPlanDoc. I searched the forum and found how to have 2 fields on FrmPlanDoc prefill based on the record displayed on FrmPlanAdminStatus. I am setting the default value on the FrmPlanDoc to the field on FrmPlanAdminStatus. That works beautifully. However, now when the form opens, it is not displaying the information saved to the TblPlanDoc that the form is based on. Any of the other fields on FrmPlanDoc that I fill in save to the table, but even though I have a filter on the button that opens the form from FrmPlanAdminStatus, based on one of the prefilled fields, it just displays the 2 prefilled fields. I tried basing FrmPlanDoc on a query and that didn't work, so I switched it to the table as the Data source. It still didn't work. I can't find anything in the forum regarding this, although I could just not be using the correct search wording.

Any suggestions on getting this to work would be greatly appreciated.

Thanks,
Stacey

 

[timryder]

I'm a bit confused on your problem, it sounds to me like you have one main form with some sort of a configuration to look at records in a table, then when you press a button, the record being viewed will open up in a new Pop-up type form? Then in this new pop-up form there are 2 controls like text box's which are bound to the filtered records from the Main Form. So then you want to edit the data in the record shown in the Pop-up form, and then you want what to happen......?

 

[Stacey]

There is a main form with the fields Group Number and Group Name. It has other fields with information about the group. The button takes the user to another form which is built on a different table, with the link being Group Number between the two tables. It has check box fields for the user to choose from, answering questions about the groups preferences as they receive the information back from the group. The information displayed on the 2 forms is totally different, with the exception of the Group Number and Group Name.

I didn't want the user to go into a blank form, I already have the Group Number and Group Name on the main table, so I wanted to bring it into the linked table without making them type it in when they enter the second form.

The point of this being, there are close to 1000 groups in the database, and the user needs to be able to get all of the data pertaining to the group they are looking at on the main form easily.

Did I explain it any better or just confuse you more?

 

[timryder]

Oh ok, so it sounds like you want to take the values of the fields in "Group Number" and "Group Name" on that Main Form and when you click on a button it populates these 2 same fields on the NEW form using the information on the previous form. Am I correct?

So now you're looking for the VB code to apply to the buttons' On_click event which will bring that data into the new form automatically?

 

[Stacey]

I've got the fields pulling the Group Number and Group Name data from the first form, and the new data being entered on the new form is saving to the table, but if you exit out of the new form, and go back into it for the same group that data was just entered on, it doesn't display the data attached to that group. I've got the button used to go in to the new form set to filter and bring up data in the new table based on the Group Number of the main form, but it isn't working.

While typing that, I just thought of something else to try, let me give it a go and I'll post after that whether it worked or not.

Thanks.

 

[Stacey]

It did not work. I hadn't tried basing the form on a query and having the query fields Group Number and Group Name refer back to the PlanAdminStatus form to get the criteria for what to display. I set that up and tried it, but it didn't work either.

 

[Stacey]

Nevermind.

I just started over, and I think the problem was that I was using an Option group for them to enter information by checking the correct option. I redid the form using combo boxes, and it works fine now.