<div>
I am not familiar with access.<br />
<br />
I already have the lable or scountryName from formA. how can I apss lblCountryName (sCountryName) to employee.CountryName in in formB?<br />
FormB pass all values to sql database.
</div>


I am not familiar with access.

I already have the lable or scountryName from formA. how can I apss lblCountryName (sCountryName) to employee.CountryName in in formB?
FormB pass all values to sql database.

<div>
What do you mean by &quot;pass the lblCountryName to employee&quot;? What do you want to do with the value in lblCountryName in regard to Employee? Do you want to filter the employees by that value, or do you want to update the Employee table based on that value?
</div>


What do you mean by "pass the lblCountryName to employee"? What do you want to do with the value in lblCountryName in regard to Employee? Do you want to filter the employees by that value, or do you want to update the Employee table based on that value?

<div>
insert that value into employee table.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a fornt end from in access which is connected to SQL server 2008.<br />
&nbsp;I have formA which has a dropdownbox that I select countryName and when I submit, I go to FormB. <br />
In formB there is a label called lblCountryName which displays the selected country from formA..<br />
<br />
I like to submit the lblCountryName to my employee table.<br />
<br />
How can this be done in access 2007?<br />
<br />
Thanks in advance
</div>
</div>


Hi,

I have a fornt end from in access which is connected to SQL server 2008.
 I have formA which has a dropdownbox that I select countryName and when I submit, I go to FormB. 
In formB there is a label called lblCountryName which displays the selected country from formA..

I like to submit the lblCountryName to my employee table.

How can this be done in access 2007?

Thanks in advance

Access 2007, form, sql db

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.