The proper code for storing the information from a combo box.
Example: Combo has list of zip codes with associated city and state.
I need to poplute the city and state fields in a "Lost Focus Event.
Me.CompanyCity = CompanyZip.Column(1)

I have a form with a subform. I would like to assign a
command button to copy the current record on the form and
the records on the subform and create a new record with
this information.

Is there a function that would allow me to set the cursor at a specific
offset in a textbox?
Reason:  I wish to use a textbox to search for a record, i.e., when the user
types the first character of the primary key in the textbox, On_Key event

I have a form (verification) that will list a number of records that need
to be verified.  It has a Yes/No field that tracks whether each record has
been verified.  The user manually clicks this yes/no button initially.
However, if the user needs to go back to the record to make ...

Has anyone written code to open a specific file with microsoft photo editor
or windows picture and fax viewer.   When a button is selected, I wanted the
access code to open microsoft photo editor... but the catch is to open with
the fetch option of a specific file name.. say on ...

i have a crosstab query and i want a button in my form that will print the
crosstab query directly not the report but the data view of the query itself.
What should i do?
Thanks.

I'm new to VB code, and need to read select data and write new table record.  
Input table A "DPS_FRQ_RC20RW" has data in it, PRTNO_NUM field does = value
20.  table B "DPS_FR_ATTORNEY" has corresponding attorney records (connected
via ATTY_NUM) field in both tables.  Table D is ...

I have an unbound textbox and a command button "GoToRecord" on a form.
When I enter an AutoNumber RecordID (e.g. "50") into the unbound textbox and
then click "GoToRecord", I move to the particular record... works great thus
far.

I am going crazy with this.  
I have a table of 80,000 rows.  It contains orders information.  Some
orders are shipped and will have a shipped date filled in.  I need to allow
the user to select a date range for the shipped field and also filter by

could someone please explain to me the role of the 'me!' function in visual
basic code? what exactly does it refer to?
thanks
jake

Dears,
I need to know how to add tabstrip in acces form ?
Any help will be appreciated
Thanks

I have a sizable select module for determining points based on a number of
criteria, I am not a programmer as will be evident by the code below.  The
problem is only the first Select Case statement is properly evaluated, the
rest are assigned a zero value.  I have verified that ...

Im making a form which asks for the details about a tenant and then
allocates a room
to them on a yearly basis (its for an academicly orientated company). I
almost have it all working, the only thing i have left is to change certain

I need to link to a textfile from the database so that the file appears as
an attached datasource in the database window. I can do it manually but I
have to do it with code.
I'm using the following but what else do I need for it to show up in the db

How do you print preview a filtered report. I wrote the following code but
it does not work. Any assitstance is greatly appreciated:   My form is
called: BONDS and my report is called BONDS.
___________________________________________________________