Form DLookup

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I'm rather new at VBA and so this question may have a simple answer. I'm
creating a form where I would like to place a DLookup in a control so that
once a choice is made in another control, the program will lookup its correct
counterpart. I have used the DLookup before, and it works. However, this
time, it seems to be in a continuous loop and freezes up the computer each
time I try to run it. Any suggestions on what might be happening to cause
this problem? If I can't get this to work, does VBA provide for a way to
create a list box for a control based on the information in a previous
control?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200602/1
.

Relevant Pages

  • Re: Form DLookup
    ... creating a form where I would like to place a DLookup in a control so that ... once a choice is made in another control, ... it seems to be in a continuous loop and freezes up the computer each ... If I can't get this to work, does VBA provide for a way to ...
    (microsoft.public.access.formscoding)
  • Re: data entry form problem
    ... Let's say the form control your using a Dlookup for is... ... Microsoft Access MVP ... happens with data field on teh form. ...
    (microsoft.public.access.forms)
  • Re: data entry form problem
    ... Microsoft Access MVP ... Let's say the form control your using a Dlookup for is... ...
    (microsoft.public.access.forms)
  • Re: Get rid of options on File Menus
    ... Even apps which have even more customizable menus than Word ... can't control that menu. ... so I doubt any of the rest of the Office programs are going to. ... > Word VBA can control menu/toolbar visibility, but I doubt they added any ...
    (microsoft.public.mac.office)
  • Re: Default but over-rideable values pulled from an unrelated table
    ... I've checked the name of the textbox control as well. ... in the DLookup() function, are you ... On the BeforeInsert event line for my data entry form I have an existing ... The bound textbox Has a control source of GSTRate which is a field in the ...
    (microsoft.public.access.gettingstarted)