How to Link a form field to sql Db table

[tkatende]

Hello there,
How possible is it to point the source control of a form field in access to a table in sql server. e.g. client id field on
a form picking up records in a client id table in a sql database.
Thanks

[blckwolf]

You question is very vague. You don't state whether you are using VBA or trying to use a sql queary as the datasource for the form.

If you are using the sql query as the data source for the form, then you simply click on the form field (I'm assuming it's a text box?) and select the data source for it - in this case, "Client id".

If you are using VBA, then you simply pass the value of your current record to the control on the form (example: "me.txtClientID.value = recordset![Client ID]").