I have a form which by a series of cascading combos get the user to select an
old record. I now want to enter something into one of that record's fields
using a text box. How do I tell that text box to add the data to the record
found in the combo above?

I am having problem with the following codes for some reason and I
cannot figure it out where the problem is. However, what I'm trying to
achive is to have a auto number generator for my quote form, so
basically this generator would create a quote number that will change

Is it possible to mark a text box on a form as not selectable?

hi
jst a quick question
if im trying to set focus to a textbox in a subform - what code would i write?
i've tried:

I have a form with a subform and cannot move from the form into the
subform.    The form is connected to a table and the subform to a form
for another table ( dont know if this is relevant).    the TAB order
has the form controls and one sub form ID control.   Any help would be

I have a database front end full of forms for data entry etc (stock control)
which links to a backend on a server. I have several basic macro's for
navigation. Theres just a small amount of VBA code for some operations I
can't get a macro to do.

I have been working on a purchase order entry system for several months and
have got things working pretty well except for a a problem I have with a
subform. I have a purchase order entry routine that has two tables -  
poheader and  poline. The poheader table contains the items ...

Does anyone have a good calulator I could add to a form ?
Thanks

I am working on a field form using access on a convertable tablet pc. In the
field tech's hand draw a small map. Can I create a form that I can hand draw
a small map and be saved into the data base.

I would like a function or Macro that will perform a date difference and
return the difference in [years]Y [months]M [days]D Format

I'd like to add code to a button on a passworded form that would open the
'tools' once I have unchecked "Allow full Menus". This way I can remove
access for everyone except from a passworded form I'm using as a menu.  Any
suggestions.

I have a pop-up form with a combo box that is populated by a table with
a record for each month of the year.  The combo box is a criteria is a
query.
I want to open the pop-up form and have the combo box keep the

I defined, on a form properties, navigation bottoms as do not show.
So, by default they are not visible.
I would like them to be visible only when the form is filter.
Is it possible to do this?

I have added an icon to my database and although I have deselected the
database window, the database window now appears?
Does anyone know why this happens and is their a way to stop the database
window appearing.

I am using the Tab Control on Access for the first time.  I have
designed my tabs in the design view, but when I go to the form view the
entire thing disappears and allI can see is a blank form.  I'd greatly
appreciate some help.