[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

Access 2007, form, sql db

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
0
shmz
Asked:
shmz
1 Solution
 
Kent DyerCommented:
Forms!formB!CountryName from your formA design mode..

That should do the trick for you..

HTH,

Kent
0
 
shmzAuthor Commented:
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.
0
 
borkiCommented:
can you post you database?
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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?
0
 
shmzAuthor Commented:
insert that value into employee table.
0
 
shmzAuthor Commented:
thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now