I am REALLY having trouble with this.  I have a small pop-up form with
a combo box.  Within this combo box are many part numbers.  There is a
"Go" button beside of the combo box.  What I am trying to get to
happen is that when the user picks a part number from the combo box,

I had the problem of the mouse scrolling through records on a form when
using the wheel and corrected it by using Stephen Lebans solution, except
for one computer which still has the problem. It's running Windows XP, as
are all the other computers running this database. Has ...

Hi...
Can u pls.anybody suggest for my below query..?
My query is....
I set Primary key for 4 field together as i need to check duplicate values

i have a continous form and i put the ff. code on  "on current" event
If Me.combo1.Value = "CASH" Then
Me.textbox1.ForeColor = vbRed
Me.textbox2.ForeColor = vbRed

i would like to create a label that would appear the word "INVOICED IN FULL"
when the my checkbox1 is set to "yes" and it will change to "PAID" when the
field1 is set to 0 value
by default it is not visible when new record is added unless the checkbox is

I was wondering if anyone knows how to fix this problem...
In my databases, I've routinely used CommandBars to hide the main menu
from the users.  For myself I can use the Shift-Bypass feature to
bypass the startup options and have access to the main menu.  I've

I'm trying to refer to a different variable each time I loop through a
procedure, as below:
I'm trying to loop through the different Menu1ItemCount,
Menu2ItemCount etc variables so as to determine how many times to loop

I am trying to write a simple procedure to be sure a selection has been made
from a combo box. I would like to call the procedure from the click event of
each button on a form.
My code is

I am having trouble referencing form objects in my custom-defined sub routine.
- In the calling statement, I pass the form as 'Me'; defining it as 'thisForm
As Form' in the custom sub's argument list. This is recognised in my
subroutine and is not a problem.

How to I set VB to automatically selecting a field (in the same way as
manually clicking on a listbox)?
I have a form with [fo_num] combo box field. After making a selection
from this field, the list box [fo_mgr] is updated.  I have no problems

I have a combo box that lists BOE ID numbers on a form (frmPricing). Once the
user selects the choice, I want a subform (sfrmPricingA) to fill in
automatically.
My code is:

I have a subform that has a text box "txtProgramName" that has
"=IIf(Forms!frmContracts!RFQType='R',"NGSS Material Replacements","NGSS COSAL
Material Replacements")" as its Control Source.
I need the correct choice to fill in the table tblLineItem.

On a subform, one of the fields is for recording the page
number from paper forms.  I'd like the user to be able to
quickly set the default value (Integer) during data entry.
I had no trouble making Command Buttons for "Page 1", "Page

Anyone know how I can do this with SelStart/SelLength? I don't know how to
specify the start to be the current cursor position.
thanks.

I've posted this here previously to some success but no resolution. I simply
need frmB.cbNavigateProfiles to open to the record in frmA.cbProfileID.
Anyone have any suggestions?
Thanks!