Open form to a specific record

[Carrie]

Hi all,

I am a newbie to Access so please go easy on me, and if you reply,
please include every detail.

I have one table consisting of info on various screw information
(size, how many in stock, etc.) Very basic.

My boss wanted to be able to search for a range of sizes, so I made a
parameter query that looks like this:
Between [first screw size here] and [second screw size here]

That worked fine.

I then created a split form using this query as the control. My boss
would like to be able to edit info on this resulting form but I cannot
edit on this form.

Is there a way to edit on this form?

If not, is there a way where I can click on the part number (my field
for this is named Insert Model Number) that is shown on this resulting
form, and have it take me to a form I already have (named Inserts)
which is basically my "data entry" form for these items?

I've tried using the macro wizard and while I can get it to open my
Inserts form, I want it to go that the specific record that I am
currently looking at so I can edit it.

Thanks!!

Carrie

 

[Golfinray]

If your table or query are not editable, your form won't be. Check to see if
the table and query have the arrow and asterisk at the bootom and will allow
you to add records. If not, your form won't allow edits either. As far as
searching your form, put a combo box on your form. Use the combo box wizard
to do this for you and select size as the source of the combo. Right click on
the combo and select properties. In properties, there will be one property
called events. Go to events and select the afterupdate event. To the right of
that event will be a button. Click that button and start code builder. In the
code builder, type:
Me.filter = "[size] = """ & me.combo# & """"
Me.filteron = true
The combo number (like combo12) will show when you start the code builder.
This will allow you to search your form on screw size.

 

[Carrie]

If your table or query are not editable, your form won't be. Check to see if
the table and query have the arrow and asterisk at the bootom and will allow
you to add records. If not, your form won't allow edits either. As far as
searching your form, put a combo box on your form. Use the combo box wizard
to do this for you and select size as the source of the combo. Right clickon
the combo and select properties. In properties, there will be one property
called events. Go to events and select the afterupdate event. To the rightof
that event will be a button. Click that button and start code builder. In the
code builder, type:
Me.filter = "[size] = """ & me.combo# & """"
Me.filteron = true
The combo number (like combo12) will show when you start the code builder.
This will allow you to search your form on screw size.

Hi all,

I am a newbie to Access so please go easy on me, and if you reply,
please include every detail.  

I have one table consisting of info on various screw information
(size, how many in stock, etc.) Very basic.

My boss wanted to be able to search for a range of sizes, so I made a
parameter query that looks like this:
Between [first screw size here] and [second screw size here]

That worked fine.

I then created a split form using this query as the control. My boss
would like to be able to edit info on this resulting form but I cannot
edit on this form.

Is there a way to edit on this form?

If not, is there a way where I can click on the part number (my field
for this is named Insert Model Number) that is shown on this resulting
form, and have it take me to a form I already have (named Inserts)
which is basically my "data entry" form for these items?

I've tried using the macro wizard and while I can get it to open my
Inserts form, I want it to go that the specific record that I am
currently looking at so I can edit it.

Carrie- Hide quoted text -

- Show quoted text -

Hi - thank you for the reply. My table and form are editable - I can
add, edit and delete records.

Are you saying I should not be using the parameter query then?

I will try your combo box idea and see how that works.

Thanks so much!

Carrie

 

[Carrie]

Hi,

Sorry to post again. I need to be able to search a range of sizes
like (from .05 to 6) for example.

How would I do that?

thanks!
Carrie

 

[Golfinray]

If you have the sizes listed in the table, the little combo box should give
it to you. When you go into the combo box wizard it will ask you what table
and what field will be the source of your combo. Tell it the table where your
size is found, then the name of the field (column) where size is found. It
will ask you for those. Once the combo is built, then use the little code I
gave you. Put in the name of the field where the size is located (like
tbl_0size) in the brackets. Then put the combo# (you will see that when you
go to code builder) in where I put combo#. It should work then. If not, post
back.

 

[Golfinray]

BTW, if you don't have those sizes in your table, you are probably going to
need to add them. I though from your original post you may already have those
there. If not, post back and we'll figure out another way. Ray

 

[Carrie]

Hi Golfinray,

I am so sorry I am such a pest with this. In my database, I only have
one table total. Do I need a separate table that will hold the screw
sizes? Right now I just have the one table with a field for screw
sizes and we were just going to type them in. Then my boss said it
would be great if we could search by screw size and come up with
results and then be able to actually go to that part number that
utilized that scew size and be able to make editions if needed. He
also wanted to be able to search by other variables (we have other
fields that show angle, thickness, etc.). Unfortunately I dont work
with the production department (who will be the ones using this
database) so some of it has been confusing for me. I think they
basically want to keep track of these screws, the sizes and other
variables of it, the material it was made from, and what project we
ended up using it on. Is there a way I could email my DB to you? I
may very well have the entire thing set up incorrectly. Which would
be icky, but I'd rather know now than later.

thanks!
Carrie