Access macro

[osmonb]

I'm somewhat of a new user. I trying to write a macro that when I double
click a field in a form it will select the data in that field ,close the form
and past in a field in a form that was open.

 

[Steve Schapel]

Oz,

This is pretty irregular, and there is probably a better way of doing this.
Can you give some more details, or specific example, of what (and why) you
are trying to achieve here?

 

[osmonb]

I'm working on a tool tracking system. In this system , I have tool issue
form. Tool issue form has a sub form ,that allows you to list each tool
issued t. There are over one thousand different tool to pick from. Just
using a comb button to pull down the stock number does not work will.
What I was trying to do was the following. In the stock number field, in
the sub form ,double clicking, opens a new form in which run a query. The
result show just a sub class of the stock number. From here I want to
double click the stock number , and have it past the value in the sub form.


Thanks

 

[Steve Schapel]

Oz,

There are a couple of approaches you can consider here.

I am not sure what exactly you mean by "sub class of the stock number", and
how this sub-classing is recorded in your database. But it is a reasonable
well-used ideea in database design to have two comboboxes, one of which you
select the subclass, and then the second only shows the items related to the
category selected in the first. This is sometimes known as cascading
comboboxes. This is probably a lot neater than trying to manage it on a
separate form.

The other thing you should be aware of is that by setting the Auto Expand
property of a combobox to Yes, you can move to a section of the listed items
based on typing the first characters of the desired entry, and this often
allows comboboxes to be used effectively, even when they are based on a big
list.