Recent content by horton_brian

So what you're saying is: I should, as I already do: 1) Store the lookup values in a separate table and use this table to populate the combo box on the form But not: 2) Use the lookup wizard in the Table Designer to set the secondary key field in my incident form as a Lookup, just leave it as a...

I've now found the event for 2) - the form's 'On Current' event. Thanks for the help. Brian

OK, I've set all the ID fields in Incidents to Number and used the wizard to make them all display the looked up text in the Table view. Thanks for your help. Brian

Sorry, I must be being thick but: The number field (Team Involved) stores a number but displays the corresponding looked up text in the Access Table viewer and the looked up text in the form Combo which has Control Source Incident.Team Involved and Row Source SELECT [Team Involved Lookup].ID...

Thanks The 'Team Involved' field does store the numeric team id because I can query it as: Incident AS I LEFT JOIN [Team Involved Lookup] AS T ON I.[Team Involved]=T.ID) and get back the team name, so the Access Open Table UI must be doing the lookup. Are you saying that for 'Role of Witness'...

Using the wizard I've ended up with two different ways to handle the Combo Box list of values for two fields called 'Team Involved' and 'Role of Witness'; both use a separate lookup table to store the value list. When the table is opened in Access, in one case the field stores the id of the...

3) Sorted! Although all my data controls fitted into the basic window, the tab control itself was too big. Brian

Thanks for that Paul: 1) Good idea, thanks - seems to work 2) Thanks, I know how to get the current values from a control, but what event would I use to change the Visible property of the control I want to appear conditionally as I step from record to record? I can't find any events for the...

I'm developing a small Access 2003 app for a local charity and it's going well using wizard-created screens, but I'm stuck on a couple of issues: 1. One of the fields needs to be automatically populated with the creation date of the record. How do I get to that? 2...