forms not joined right

[emzadi]

I have a main form, titled "Applicants." I have several other forms; for example, "Payments" and "Employers." I would like a command button on the applicant form that will pull up the payments form already filtered for only that applicant's entries. That is working okay. Now, I need two more things right off.

1. Once I have the payments form open, I want a command button that says "add new payment." However, at this point, the user has to remember the ID number for that applicant and enter it into the joining field. Shouldn't it come up automatically since the tables are joined on that field?

2. I need to make the form read-only until the user clicks "add new payment." I do not want current records being edited.

Help?
I am also open to completely different ideas of how to get this to work.

Thanks,
emzadi. Susan M. Wagner
LAPELS
susanw@lapels.com

 

[AlexMidd]

1. Presumably your payments form is set to a query that returns only the payments for that applicant. If you include the id number field in that query you should be able to add a field showing the number on your form.

2. Set the AllowAdditions property to false in the code that opens the payments form. Then set it to true when the user clicks the "add new payment" button.

Hope this is of some help.
Alex Middleton

 

[emzadi]

1. Umm, nope, I used a wizard to connect the forms. It has a field showing the id number, but it comes up blank and must be filled in by the user. Seems like it should come up with the filtered id number already in it? So I'm still kinda stuck on this one.

2. Yes. Thanks! That worked.

Susan M. Wagner
LAPELS
susanw@lapels.com

 

[simco]

1. Include in the main form a subform for the payment and set the joined field to the id number instead of opening a separate form for payment. This will solve the problem with the id.

Hope this helps.