Solved

Update a table

Posted on 2011-03-16
2
196 Views
Last Modified: 2012-05-11
Experts,

I have a form frmLetterOfCredit_Cont that is built off of tblLetterOfCredit.
I also have a form frmLetterOfCreditAdd built off of tblLetterOfCredit.
What I need to do is update [region] that is contained on frmLetterOfCreditAdd without having to actually go to this form.  
[Region] is a combo box.

While on frmLetterOfCredit_Cont I enter in the "Country" from cboCountry on this frmLetterOfCredit_Cont and after I update this I want to be able to update this field named cboRegion [Region] on frmLetterOfCreditAdd

both forms are built off of tblLetterOfCredit.  

The reason I want to update cboRegion instead of actually going to the form is becuase the network is a little slow and I do not want to transfer this field to frmLetterOfCredit_Cont but let it remain on frmLetterOfCreditAdd.  

cboRegion on frmLetterOfCreditAdd rowsource:
SELECT tblRegion.ID, tblRegion.Region FROM tblRegion ORDER BY tblRegion.Region;

I guess I would need an unbound form with cboRegion on it and then once I select one of the options from the dropdown box then the [Region] field on tblLetterOfCredit would update with what I selected from this unbound field on a form called say frmRegionPopUp.

Maybe there is a much simpler way to do this.  I am open to suggestions of how I could update the value on the combo [Region]  under tblLetterOfCredit while on frmLetterOfCredit_Cont without having to actually go to that frmLetterOfCreditAdd where [Region] resides.  Keep in mind that the both forms contain tblLetterOfCredit and I could get a WriteConflict error.  

LetterOfCreditID is the link between the forms frmLetterOfCredit_Cont and frmLetterOfCreditAdd.

thank you.  Please ask questions if not clear.

I attempted to do this myself with an AfterUpdate on cboCountry but did encounter a write conflict error (but now I believe an UNBOUND form would be better than a bound form which is what the frmRegionPopUp was built off of (tblLetterOfCredit).

Private Sub cboCountry_AfterUpdate()

     If IsNull(Me.cboRegion) Then
        MsgBox "Enter the Region of Export on the LC Detail form (click LC No)", vbInformation
    '    DoCmd.OpenForm "frmRegionPopUp", , , "[LetterOfCreditID]=" & Me.ID, , acDialog
    'Me.Refresh ' have an issue with write conflict...removed docmd. 3/15/11 have tried refresh, requery, dirty...posted EE.
   
    End If
   
End Sub



Hope it makes sense.  Let me know if you have any ideas.  

0
Comment
Question by:pdvsa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Author Comment

by:pdvsa
ID: 35147607
There are a lot of words there.  Just a summary:  I want to update tblLetterOfCredit [Region] without having to go to the frmLetterOfCreditAdd.  I want to do this while on frmLetterOfcredit_Cont.  

I guess I could drag [Region] on the frmLetterOfCredit_Cont and hide it then make it visible but it would look a little funny becaus I have no space for [Region] on frmLetterOfCredit_Cont.
0
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 35154233
If control is not visible, you can put it behind any other control. It will be not easy to edit (you can use Tab to move between controls).
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question