I try to create form in module.(I dont use any standart form)
I just use code in module for everything but I can't create form with code=:0(
Somebody can help me?

hi i didnt use autonumber for my ID
i want to upon form loading for it to take the table data and find that 20
was the last ID# so then take that # and increment it by 1 and then place
the new number (21) into the ID# field on the form when it opens.

Is there a way to trigger an event (such as setting a textbox value) by
merely selecting a page on a multiple page form?

I have a main form /subform set up. On the main form, there is a combo box
that restricts the records in the subform the the value that is chosen on
the combobox.
Works great.

I want to key in details of PRs for a particular IO. IO details will be
displayed in a subform and PR details in the main form. IO details is control
by a parameter query. i want to pass the same parameter details into the main
form. For example, when i key in the IO number in ...

I'm getting a Reserve Error don't have a clue what it means. I'm getting
this doing an Update Query from a form. Anyone have any ideas. I also just
installed the services patch 3 for OfficeXP Pro Developers version and
Windows XP service patch 2.

I have a form (frmTop) for different purposes. This form is not set as
"popup" in design time.
Now I want to open this Form and want to show it on top of all other windows
(Forms), same as popup form.

I have 4 order forms that require the same actions
I would like to make a subroutine that I can pass the form object to
objectify these actions
I have a call to a procedure:

In the form I would like to move some of the feilds in the current record to
another table as a new record. I would like to achieve this by using a
command button , but I'm not sure how to even start the coding for this.
I know my question goes against basic db design concepts, ...

I have several bit field in my SQL table. When I put those field in form,
Access display those field as ordinary text field. How I do put those field
as CHECK/UNCHECK format?
SF

Form Subform Problem
I am having difficulty synchronizing my forms and datasheet subforms that I
use as a lookup  (I do not want any changes or updates in this layout!). I
have a text box that I input a part number that feeds info to a select query.

I've a list of records displayed on a continous subform.
How could I display another form by issuing a right mouse click on a
specific record?

I have a piece of code I am working on in a mdb (front end for a SQL
database)
----------------------------------------------
  Set rst = db.OpenRecordset(SQLStmt, dbOpenSnapshot)

I have a form that has a combo box and a list box. The list box is based
  off of the selection for the combo box
cboBox Rowsourse=
SELECT distinct TngType FROM tblEvents UNION select "[ALL]" from

I am trying to set up an event scheduler where the user can enter the event
information on a form and on the same form, select several dates on a
calendar control. The form will then create a record for each date selected
with the event information in the record.