Tabular form

[dazoloko via AccessMonster.com]

Dear All

Im hoping someone can help me.

I have a table containing personal information relating to service users.
Within this table is a Key Field DP number.

I also have a table which contains Financial transactions of service users.
The fields are Transaction Date, Transaction Type, Transaction Amount

What I want to be able to do is to enter multiple transactions relating to a
particular service user.

I thought the way around this would be to create a tablular form where I can
just tab through to the next transaction on completion of the previous one.
Where though, would I enter the DP Number ?

Hope this makes sense.

Cheers

D

I only want to enter the DP Number value once though

 

[Dale Fye]

Rather than using a Tab control, use a subform.

Create a form based on your Transactions table (there should also be a DP
field in that table). then add a subform to the main form, set the
SourceObject to the name of the transactions form, then set the Link
master/child fields to your [DP] field.

Now, when you select a record in the main form, the subform will display
those transactions that pertain to that DP. And when you add a record to the
subform, the [DP] field will automatically get filled in with the [DP] value
in the main form.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[dazoloko via AccessMonster.com]

Thank you kindly for your response, nuch appreciated.

D