If change table field prop, have to remove & replace form button

T

TravelingHT

If I change an underlying table field property, I find I have to delete the
corresponding form text box and then replace it from the field list to have
the changes propergated.

Is this normal and god what a nightmare.

Thanks in advance.

Traveling Histologist
 
L

Linq Adams via AccessMonster.com

Doesn't appear to be in v2003. Data in the converted field that doesn't meet
the datatype criteria will be deleted, but you shouldn't have to change
anything at the form level, I wouldn't think. In the original control on your
form, do you have anything set in an Input Mask, Format or Default Value that
might conflict with the new definition of the underlying field? Exactly what
kind of field are we talking about and what property did you change?
 
T

TravelingHT

I am having emence trouble, I have added the post to explain what I have been
trying to do.:

I want to populate the Pet ID, (which brings up the pets name) in a combo
box in a sub sub form, with only pets owned by the customer who is the focus
of the main form. (See the bottom of the screen to see the structure of the
tables.)

The combobox for Pet ID is in a sub form of a sub form of the main form Trips.

The main form is called Trips and has the foreign key CutomerID.

The master/child fields linking the forms are TripID- Visit ID :
VisitID-PetsAtVisitID

The pet table (from which I am trying to populate the combo box) in the sub
sub form has the foreign key CustomerID but from the main form to the sub sub
form I have different foreign keys and doing the linking.

1.I am not sure if I should be using a query or an expression.
2. I am assuming I should be putting an expression in the properties of the
combobox of the form “PetsAtVisitâ€.
2a. If I am to use an expression in the properties of the combobox, under
what property heading should I put my expression i.e. “Row Source†etc.



----- Customers ------
|............................|
|.........................Trips -Main Form From (Based on table Trips)
|............................|
|.........................Visits - SubForm (Based on table
Visits)
|.............................|
Pets....................PetsAtVisit - Sub Sub Form (Based on table
PetsAtVisits)

Some of my customers will show animals so not all the pets will be there all
the time.

Also as an asside some(or probably all) will die. So I have added a check
box "Pets Decieced" But I will have to work that one out.

END OF EXAMPLE OF WHAT I AM WORKING ON.

So I tried unsucessuflly, I still am pulling my hair out on this one, an
expression and it did not work, so I removed the epxression and it still did
not work so I removed the control on the form and then went to the control
list and repopluated that control back onto the form and it worked.

I see the general nature of my post and difficulty in fixing the problem, if
it acutally exists!

Thansk for your help. I will check my settings.



--
Anthony Williams
Histotech Exchange LLC
19 Whitmore St.
Lexington, VA 24450
[email protected]
 
T

tina

i have some difficulty following what you're doing, but i'm wondering if you
have a Lookup field in your table? and changed the RowSource property at the
table level, hoping it would propagate to a combobox control on the subform?

if so, then i'd recommend first that you get rid of any and all Lookup
fields at the table level. for more information, see
http://home.att.net/~california.db/tips.html#aTip8.
you don't have to get rid of the *field*, just the Lookup, by changing the
DisplayControl property from ComboBox to Textbox.

combobox controls in *forms* are fine, no problems lurking there. but if you
want to change the RowSource property of a combobox control in a form, you
have to do it at the form level. and note that a change to a combobox
control in one form does not automatically propagate to combobox controls in
other forms that are bound to the same table field.

hth
 
T

TravelingHT

Dear Tina:

Well you found a problem I certainly had. I have committed sin number 8 and
I am gong to rectify that. I have also committed sin number 10 multiple
postings of the same thread. For this I am truly sorry and will stop, I
apreciate all the help I get from all of you and will some day provide help
to those I can.

Thanks to you Tina and all the other good hearted people out there.

I will be back on tomorrow to tell you if this fix worked.
--
Anthony Williams
Histotech Exchange LLC
19 Whitmore St.
Lexington, VA 24450
[email protected]
 
T

tina

you're welcome, Anthony, and with such a positive attitude and willingness
to learn, i have no doubt that you'll expand your skillset quickly and soon
be able to teach as well as learn here in the community - as we all do. :)
 
Top