Accessing Access database in the VBA form

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Forms / October 2007

Accessing Access database in the VBA form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ashish - 30 Oct 2007 11:26 GMT

Hi,

I have a form in which i have a combo box and a comand button.
Now based on the values selected in the combo box, i need to "update" a
field in the access table. The form and the access table are not linked.

Please let me know how can we do this?

Reply to this Message

Pieter Wijnen - 30 Oct 2007 11:36 GMT

With limited info givven:

Private Sub Cmd1_Click()
CurrentDb.Execute "UPDATE myTable Set Myfield1=' & Me.combo1.Value & "'
WHERE MyField2='" & Me.combo1.Column(1) & "'"
End Sub

Pieter

> Hi,
>
[quoted text clipped - 3 lines]
>
> Please let me know how can we do this?

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.