FAO Anyone who knows stuff about Microsoft Access...

[Spunkmonkey]

thought it'd be simple enough, but Access is being an arse... so, does anyone know how ya' "bind" two fields in a table/form together so that when one changes its selection (from a drop-down box in a form) the text box/drop down box for the other field changes accordingly?

 

*if anyone actually understands what i'm askin' i'll be suprised*

 

so, anyone help me out here then?

[FredTheBaddie]

I know it's [censored].

[FredTheBaddie]

Use javascript.

[Spunkmonkey]

ummm

 

i'm tryin to keep the lil' fucker as simple as possible *like me * urm...so that kicks javascript up the arse... plus i wouldn'e know where to start wiv' it neva

 

anymore suggestions anyone?

[alasdairm]

is this what you mean:

 

http://support.microsoft.com/default.aspx?scid=kb;en-us;209595

 

alasdair

[Rick D]

yeah, on the change event use a DLookup...

[Rick D]

That is the simplest way, you can also set a SQL statement to the rowsource... i.e.

 

object2.rowsource = "Select field From table where field '" & me.field.value & "'"