Display field linked to the field that i entered

mymy

Registered User.
Local time
Today, 00:52
Joined
Jun 18, 2001
Messages
16
Ok My problems might seem quite easy but I begin to learn access by myself. I use Access2000. My problems (because I got 2) are: I have a form with a subform (2 different tables). In my subform I have 2 fields: "packet_number" and "PMP" (that is linked with the packet_number) . What I want is when the user enter a packet number that already exist to display the PMP beside it. For the packet_number I use a textbox.

The other problem that I have. In the same form, I have to calculate how many packet the user enter and I have to do the sum with the PMP (the PMP field is numeric). I put invisible fields on the sub form to do that. And I display it in the form's foot. Everything is ok for that. The problem is. I put this calculation on the control source. But I want that these field are saved in the table. So Where I should put the calculation or the field's name to save it in my table?

Thanks in advance.
Mymy
 

Users who are viewing this thread

Back
Top Bottom