OPen Form to add data

[joemills62]

HI all



Im am sure this must be simple

I have a client list amd i want to add activities to it.
1. the form is called company list, showing company name (text Filed). i have an add button to add data to the activities table using a form called activities,

This work fine, but i want the field in the activities form to be pupolated with the company name, the field in the activities table is called companyid (text)

I have tried the code

DoCmd.OpenForm "activity", acNormal, , "[companyid] = " & [company list]![company name], acFormAdd, acWindowNormal

Any help

[RuralGuy]

It sounds like you should handle that in the RecordSource of the Activities Form with a Join. Do you really have [companyid] set to [company name]?

[joemills62]

Many Thanks for that,
no the company id is not linked anywere ?,
but i did mead compaid = idno ??, which is a numercial number

not sure how do a join, and how that would work ?

[RuralGuy]

You would use the Relationships menu under Database Tools to effect the join.