Første combobox vælger jeg vognmand, nr to vælger jeg en chauffør. Når jeg har valgt en chauffør skal oplysningerne på den pågældende chauffør vise sig i en række tekstbokse.
"Giver det bedre mening nu? " Yes, but its actually another question :-)
After selecting a "chauffør" you want to show all the details for only that "driver, yes?
THere are a couple of ways you could do this.
1: If all of the drivers details are in columns in the combo box, and the fields on the form are unbound, you could move the data from the columns in the combo, to the unbound fields on the form.
2: If only some of the drivers details are in columns in the combo box. And the fields on the form are bound. (Form has a record source) You could filter the form using the forms filter property.
EG: In the combo's AfterUpdate property you would add some could like this.
As I dont know the names of tables/fields I used DriverID which you should change to the correct field name EG:
chaufførID
It will very likely be unique field name (primary key) in the tabel and also first column in combo
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.