Populating a field (table) using a textbox

[Sniper-BoOyA-]

Good Afternoon,

I am working on a form (continuous). And right now, the user has to enter the diameter for every sample number.

Is it possible to add a textbox to the form, and let the value of that textbox be the value of all the fields in the query/table?

So the user only has to enter the diameter once?

 

[vbaInet]

You can put the textbox in the header or footer section of the form.

 

[Sniper-BoOyA-]

Thanks,

But is it possible to copy the value of that textbox, to the table which is the source of the form?

Ive tried the following:

[Tables]![tablename]![fieldname].Value=me.textboxname.value

But unfortunately that doesnt work.

 

[vbaInet]

That depends on where you put that code?

 

[Sniper-BoOyA-]

That depends on where you put that code?

I put it in the afterupdate event of the textbox.

 

[vbaInet]

So it's:

Me![[COLOR=Red]FieldName[/COLOR]] = Me.TextboxName

 

[Sniper-BoOyA-]

Thanks. Worked like a charm. ^^

 

[Sniper-BoOyA-]

Well i thought it worked like a charm...

It populated the fields on the form just fine, but not the table itself.

I am starting to think i'd have to re evaluate the design of the table(s).

 

[vbaInet]

If the control in the Detail section is bound to the field then it will get saved.

 

[Sniper-BoOyA-]

Sorry for the late reply.

You are right, when i make it a bound textbox, it saves the value in the table.

But only for one sample at a time. Which means if i have 6 samples, i'd have to enter the value 6 times.

Isnt there a way to set the defaultvalue of a field(table) to whatever value a textbox has on a form?

The reason why im asking this is because up to this point, the value of the textbox will be lost when i close the form.