Navigating fields on Access forms

  • Thread starter Thread starter Mondou
  • Start date Start date
M

Mondou

I am a rookie with Access and trying to build a product database that
will be linked to about 1,000 pictures.
My goal is to be able to use this database to view STYLE NUMBERS,
DESCRIPTION, PRICE & PICTURE of each item in a catalog of over 1,000
various products.
In my first step, I have created a form with this info. To navigate to
a specific specific product, I would like to be able to simply write
the style number in the STYLE field .
I have tryied to use the "GoToRecord" Macro to accomplish this but it
doesn't seem to work. In the STYLE Properties of that form, I selected
the appropriate Macro in the dropdown list of the "On Click" event.
However, I simply cannot write anything in the STYLE field...Access
just won't let me.
Can anybody give me some pointers?
Since I don't know much about VBA, I don't think that this is an option
for now.

Thanks for any suggestions
 
You can try using the 'find' button on the toolbar.
Click in the field you wish to search and then click the find button (or
Ctrl F)
Type in the search, Click OK

If this does what you want you can put a button on the form that does the
same.

In the command button wizard use Navigation, Find Record

If you want anything more elegent you will have to code it!

John
 
Thanks a mil ! hadn't though of that.

About the Newsgroup, my mistake, (new joiner)
I'll reply back to the newsgroup so that others may benefit from this.

Thanks again

Mondou


John Milward wrote:
Mondou

You cant enter a search criteria directly into a field, because what
you
are trying to do is change the data in that field.

Typically you would need to put another text box on the form.
Then use a button to use the value entered in that box as the source
for
a record find.

Try this link for more info
http://www.databasedev.co.uk/text_search.html

PS You should really reply to the Newsgroup, since this makes the
information available to all.
Also it is worth using Google to hunt for solutions.
I found the above link by searching for 'access findrecord'

Regards

John



Mondou wrote:
Thanks for your response but I already have done this and it works
fine.

However, I'd like to try and enter the Style number directly in the
field itself to save some time since I lookup items frequently. Would
it
be very complicated to code it?

Also, why can't I write over data to edit it in forms? I've seen some
Access examples that let you do this. I've looked at the form
Properties
in these examples but can't see anything different.

Do I have to change certain properties in the Tables or Queries ?

Thanks again

Mondou
 
One more thing,

Can anyone tell me what I have to do to be able to edit the data in my
forms?

It won't let me change anything.

Thanks
 
Back
Top