Question for Marsh if possible.
I have a text box named P1Bill1Name and...
Another text box named P1Bill1Paid.
If  P1Bill1Name has text in it I want P1Bill1Paid

I have a drop down box Listed as " Status" This drop down box contains 6
different status's. I want to auto populate a field called "Date Of Status"
With the current date, each time the status is changed.
However there are two status named "N" and "RJ" where another date field

I have a text box in my form where i input the quantity for the amount of
that item im selling, what i want is for that amount to automatically be
substracted out of the table so if i have 99 hard drives and i make an
invoice (my form) and sell 3 the table will read 96 the next ...

I have a form where Invoice information is entered into a subform. If an
Operation Code (OpCode) is entered into the dropdown that is not in the list
a form is opened to a new record so that the new Code can be entered with a
description using NotInList. This works fine.  What I ...

Great admirer of this site:
I built a multi listbox that has many columns. I am trying to use the
column(x)
property to pick up the additional values in each selected row.  The

I am trying to modify values of the currently selected record of a form in VB
Code.  The following gets called when the check box is clicked on a treeview
on the form:
   rs.Edit

Is there a way to have a form open but invisible to the user? I am running a
couple of forms that contain code that gently logs users off the app after 5
mins and it requires a form to be open to check a table field every 5 mins
(Can't remember where I got the code, but it works ...

I would like to have the drag n drop function working on a single memo field
on a form.
my idea is that the user should be allowed to mark a part of text and drag
and drop it within that memo field rather than cut and paste it via

I have a combobox that I have set.focus to but get the error message above,
but it updates prior to the error.  Need Help

I have a form with customers and the user can select customer id/name via a
cboSearch combobox
now some buttons with the letters of the alphabet should make it easier.
I've done some code for 6 buttons each with the corresponding Caption ...

I need a form button to open a report to the record that's open in the form.
I've tried the following code but get a syntax error. I'm sure it lies within
the "Forms! & Me!form & [txtProfileID]" string.
Anyone see how I can resolve this?

I have a form that has a subform.  I need to create a button on the main
form that sets the focus to a particular field on a subform.  How do I do
this?
Thanks,

I'd like to display the record number and the number of record numbers on
the form instead of in the navigation bar.  e.g Record [current record
number] of [number of records].  I realise this is probably fairly easy, but
I can't find out how to do it after searching the online ...

i have a form that displays info by week.  So that the users can see and
remove weeks as they please, i have buttons, that will display each week.
That part of form is Ok, but when a week is selected, it will appear right
where it is in the design mode, which it is supposed to.  now ...

I usually don't use the wizard, but I just noticed when I select the Command
button from the toolbar, the wizard does not start.  Why would it suddenly
not initiate?  Is there a link/reference missing?
Bernie