Empty a bound textbox (?)

[Guest]

Hello!

I have a form based in T_Imgs with unbound combobox and two bound textbox.
When we open the form the combo is empty but the two textbox show us the 1st
record values of the table.

I would like to open the form and, before the choose in combobox, with two
textbox empty too.
Is it possible in Access2K.

Thanks in advance.
an

 

[Guest]

hi,
not with bound text boxes.
why do you want they to empty at start up?

regards
FSt1

 

[Guest]

Thanks for your reply.

Only because i would like to show after choose option in combobox.
an

 

[Rick Brandt]

Thanks for your reply.

Only because i would like to show after choose option in combobox.
an

Does the ComboBox apply a filter or cause the form to navigate?

 

[Guest]

hi,
bound text boxes are bound to the data in the tables. it will show the data
becasue you told it to by binding the text box to the data.
if you want them to be empty at start up then you may have to regroup your
prodecures and methods. bound text boxes would be the easiest and simplest
way to do it but bound objects have a way of building in problems down the
road.
careful thought should be given before binding anything.

my opion.

regards
FSt1

 

[Guest]

Yes I do.
I have in Row Source of the Combobox

SELECT [T_Imgs].[Description], [T_Imgs].[SectorQ] FROM T_Imgs ORDER BY
[Description];

Thanks.
an

 

[Rick Brandt]

Yes I do.
I have in Row Source of the Combobox

That doesn't answer the question I asked. What is the purpose of the ComboBox
and how does it accomplish that purpose?

 

[Guest]

FSt1,

Thank you for your explanation.
an

hi,
bound text boxes are bound to the data in the tables. it will show the data
becasue you told it to by binding the text box to the data.
if you want them to be empty at start up then you may have to regroup your
prodecures and methods. bound text boxes would be the easiest and simplest
way to do it but bound objects have a way of building in problems down the
road.
careful thought should be given before binding anything.

my opion.

regards
FSt1

 

[Guest]

Sorry.

Through of the ComboBox in MainForm, we choosed the description of images
and show us the respective image in SubForm.
The TextBoxes tell us the respective number of the Sector of the image showed.

I don't know if I was explicit.
Thanks.
an

 

[Rick Brandt]

Sorry.

Through of the ComboBox in MainForm, we choosed the description of images
and show us the respective image in SubForm.
The TextBoxes tell us the respective number of the Sector of the image showed.

I don't know if I was explicit.
Thanks.

Sounds like the main form is bound to a table and should not be. All you are
using it for is to determine what to show in the subform. The main form need
not be bound for that.

 

[Guest]

Thanks RB

I supposed the possibility somewhat of next:

If([Combo108] Is Null;"";[IdSector])

an

 

[Guest]

Problem solved with intermediate TextBox.
Thanks for all.
an

 

[Guest]

Problem solved with intermediate TextBox.
Thanks for all.
an