Not Updateable

[nx69]

I want to make a form where a staff member will book a bet, by selecting MembersID(which will automatically fill in, fields like name and surname) and Race, where this will allow the staff member only to select horses within that race.

1) when i try to select an other ID i get a msg at the status bar, this field is not updateable. why is that?

2) how can i achieve the second part? I have a tblBets a link table tblRace(races are kept here) and a tblHorses(horse and race).

I'd really appreciate some help here. Thanks.

 

[dcx693]

For (1), I'm guessing that you're basing this form on a table, that the ID field is the primary key field for your table and that it's an autonumber field. Also in your form, it's probably a bound field (meaning that the controlsource for the control is the ID field).

 

[nx69]

em

thanks for your responce but to be honest what you tell me is not something new, a way to solve it would be more welcome thanks again