Repeat (Repetitive) Information Entry Through Access Form.

[Peader]

Hi,

I'm looking for advice on the best way to set up a new database considering the following:

I want to use one form to enter 4 fields
9 out of ten times the information in those fields will be the same.
For the 9 out of ten times the information is the same I only want the user to have to click the command button to enter the new information.
On the 10th time I expect the user to select the alternative information from a combo or text box located on the form.

I've tried preparing a table, linking each field to a bound combo/text box on the form however this leads to issues when I simply try to enter the 9 out of ten pieces of information (the system appears to need to be update once before it recognizes and allows a save to the table, this eliminates my ability to meet the one click information enter requirement!!).

Any alternative ideas/methods for me to try out over the weekend?

I understand my description is vague however I'm find I understand it better if I'm point in the right direction and then allowed to follow the path myself :)

Thanks in advance,
Peader

[Rabbit]

So... can't you use the default value property?

[Peader]

Hi Rabbit

While 9 out of the 10 times it will be the same. The value will change from time to time (its a part number and we develop new parts monthly). You could say 90% of what we sell is the same however this 90% changes depending on the season.

I've tried to set the default value however I run into problems (I can't confirm exactly why however I suspect its because I use a bound text box), I need to reselect the text box between every command button click.

I'm now looking into trying to set the text button to autofill on the previously selected item if left blank. In theory this should allow me to select once and on consecutive click it should autofill!! Well thats the plan....

As always your advise is very much appreciated, I'm not a programmer so your experience is invaluable to me.

Regards,
Peter

[Rabbit]

Well, for the default value to work properly, the textbox has to be bound so that's not the problem. The default value fills in whenever you are on a new record.

What is it that your command button does?