Hey guys not sure if im on the right section here but i will give it a go
i have a table called EPOS_LAYOUT
ID Short Text PK
BUTTON NAME Short Text
POS Short Text
I have a form with command buttons on going from CMD_1 - CMD_40
I am wanting to open the form and ON OPEN i want the CMD_1 command button to use the value of BUTTON NAME as the caption on the record ID 1
this means that i will end up with the last one CMD_40 with the BUTTON NAME for record ID 40
I have been looking at a way of using DLOOKUP but i have just been given error codes and after hours of looking online and a few days racking my brain i have hit a wall :banghead:
any help will be great
cheers guys
i have a table called EPOS_LAYOUT
ID Short Text PK
BUTTON NAME Short Text
POS Short Text
I have a form with command buttons on going from CMD_1 - CMD_40
I am wanting to open the form and ON OPEN i want the CMD_1 command button to use the value of BUTTON NAME as the caption on the record ID 1
this means that i will end up with the last one CMD_40 with the BUTTON NAME for record ID 40
I have been looking at a way of using DLOOKUP but i have just been given error codes and after hours of looking online and a few days racking my brain i have hit a wall :banghead:
any help will be great
cheers guys