By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,215 Members | 1,517 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,215 IT Pros & Developers. It's quick & easy.

Calling a text box in Code Editor

P: n/a
Thank you for take the time to read my problem!

I'm trying to delete a record in a table with VB code. I have done
this many times and this is not my issue. I need to call a text field
on my Form. I can't seem to figure out the correct syntax for make
the call.

Here are the objects that are involved with my de lima.

FORM = frm_AddEdit_Equipement_Master:
listbox = lst_EquipID
subform = frm_Equip_Tabs
Tabcontrol = TabCtl0
TAB = IP Info
Button = Delete IP record
subform = sfrm_IPAddresses
text field = txt_IPID (IPAddress.IPID)

I need to complete this statement.

SQLDelete = "Delete from IPAddress_tbl where IPID = " & syntax here

Also could you refer me to where I read and learn more about how to
derive this information myself?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

SQLDelete = "Delete from IPAddress_tbl where IPID = " & Me!TextBoxName

Read the Help articles on queries and query parameters; also, the VBA
help articles on "Form Property."

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQMYGHoechKqOuFEgEQJqvwCg4sZZKWOj3tV2+ebAAZSnak QprtAAoLHz
qYzaqi1pZx9OwNFdUi4jxM1D
=0VZP
-----END PGP SIGNATURE-----
N. Graves wrote:
Thank you for take the time to read my problem!

I'm trying to delete a record in a table with VB code. I have done
this many times and this is not my issue. I need to call a text field
on my Form. I can't seem to figure out the correct syntax for make
the call.

Here are the objects that are involved with my de lima.

FORM = frm_AddEdit_Equipement_Master:
listbox = lst_EquipID
subform = frm_Equip_Tabs
Tabcontrol = TabCtl0
TAB = IP Info
Button = Delete IP record
subform = sfrm_IPAddresses
text field = txt_IPID (IPAddress.IPID)

I need to complete this statement.

SQLDelete = "Delete from IPAddress_tbl where IPID = " & syntax here

Also could you refer me to where I read and learn more about how to
derive this information myself?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.