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  

Combo Box to write to table(s)



 
 
Thread Tools Display Modes
  #1  
Old May 25th, 2010, 05:39 PM posted to microsoft.public.access.forms
EBaker via AccessMonster.com
external usenet poster
 
Posts: 2
Default Combo Box to write to table(s)

Hello all,
I am having difficulty with the following issue (Access 2007)
primary form (frmMain) contains user information with various fields. Key
field is ID (this is input at the time the record is created) and a combo box
named cboAction with the following options:
MMRB
MEB
P4
ND-PEB

Within this form I have the following subforms:
frmMMRB
frmMEB
frmP4
frmND-PEB

When the user selects MMRB from cboAction, it needs to write the ID to the
appropriate table (MMRB)
(Other selections write to other tables (tblMEB, tblP4, etc) and then make
the subform visible.
I can get this part to work.

The frmMMRB contains another dropdown pulled from another table (cboselMMRB)
that selects the brdID and the date, but only showing the date in the drop
down.
All of that to get to this:
I cannot get the cboSelMMRB to write the brdID into tblMMRB where the id
from the frmMain was just inserted.
This is the only table that needs to have the brdID written to it-none of
the others have a brdID assigned, but are linked by the ID of the main form
and the ID that was written to it from the cboAction combo.
This has been driving me nuts for several weeks, but I am sure there is a
simple solution I am overlooking. I am new to VBA, so any help would be
appreciated.

--
Message posted via http://www.accessmonster.com

 




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


All times are GMT +1. The time now is 10:31 AM.


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