Strange Combobox autofill behaviour

[Trodelphin]

have a form where the initial field is a combo-box
if i complete the form then start another if in first combo box i choose the same selection it loads the previous values in other fields instead of continuing with a fresh one
any ideas ?

 

[vbaInet]

Sounds like that combo box is filtering the records on your form.

 

[Trodelphin]

yah its a strange one i cant seem to see any thing in the filter
i changed my navigation from next form to close form--reload form--go to new record and that seems to work fine but be nice to know where the bleed comes from

 

[John Big Booty]

Can you post a copy of your DB? (pre '07 version)

 

[Trodelphin]

im afraid its a 07 Db and i cant change it to a 03 because of certain used features

but here it is in 07
To see Behaviour

go to New Form
select a JobNo
put something in the Decription dropdown then go the the next form NOT NEW FORM
then in Job No choose the same one as before and watch it pull in the description data (which it isnt supposed to)

 

[Trodelphin]

it seems to behave like this regardless of restarting the form or going next for the first record but after that choosing any but value of first record works fine just if choose first one will it autofill

 

[Trodelphin]

ok figured it out had 2 master/child links in my mainform/subform instead of the single which was causing my problem

now to fix my reports and combo box lookups which worked under old system :/

 

[Trodelphin]

ok if i were to take this simple sample data base as a example and wanted to add say a further parent field called Hospitals
so it would be ;

Hospitals ---PersonID-------FRM_Metodologies
............................-------FRM_Sistems

then wanted to to a report of Metodologies and Sistems by Hospitals
where would the link go ? as it is the link is between the last 2 subforms not the 1st (PersonIS and (FRM_Metodolologies,Sistems))


at the moment if say i create a field HospitalNo on all the tables which links from a Hospitals Table to PersonID table then a second parent/child between PersonID and Metodologies,Sistems Subforms i get the report working fine and fields all look good for lookups etc but then i get my problem of when selecting a hospital on a new PersonID Form it pulls in all the data to subsequent subforms

 

[vbaInet]

Trodelphin, I think a question like this would warrant a new thread. Create a new thread (in the appropriate section) and we'll take it from there.