A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

HELP Please! - Unbound Controls to update record



 
 
Thread Tools Display Modes
  #1  
Old May 10th, 2006, 03:29 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default HELP Please! - Unbound Controls to update record

I am desperately trying to find a way to use an unbound textbox on a control
to update a record. The text box in question is populated with information
based on a selection in a related combobox.

Can anyone help?
  #2  
Old May 10th, 2006, 03:51 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default HELP Please! - Unbound Controls to update record

Hi,

Use the AfterUpdate event for the combo box and bind the value to the text
box.
E.g.
me.mytextbox = me.mycombobox.column(0).

Remember columns are zero based.


Zoltar54 wrote:
I am desperately trying to find a way to use an unbound textbox on a control
to update a record. The text box in question is populated with information
based on a selection in a related combobox.

Can anyone help?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200605/1
  #3  
Old May 10th, 2006, 06:42 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default HELP Please! - Unbound Controls to update record

That part of the code I have however I am not able to have the information in
the textbox added to the record table. Is this possible?

"sike11 via AccessMonster.com" wrote:

Hi,

Use the AfterUpdate event for the combo box and bind the value to the text
box.
E.g.
me.mytextbox = me.mycombobox.column(0).

Remember columns are zero based.


Zoltar54 wrote:
I am desperately trying to find a way to use an unbound textbox on a control
to update a record. The text box in question is populated with information
based on a selection in a related combobox.

Can anyone help?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200605/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
error message apears keen but dumb General Discussion 3 October 7th, 2005 11:20 AM
strategy for data entry in multiple tables LAF Using Forms 18 April 25th, 2005 04:04 AM
How do I add a new record from unbound controls to an existing tab pint7 Using Forms 3 December 10th, 2004 01:10 AM
Update current record information to a separate record status reco Pete Sperling Using Forms 8 August 6th, 2004 01:23 PM
Form Doesn't Go To New Record Steve New Users 15 May 16th, 2004 04:33 PM


All times are GMT +1. The time now is 10:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.