Recent content by three-pins

Thanks for the revised code - this works well for me. As a matter of possible interest, what started this enquiry was as follows. I have a database that allows for special conditions to be added to an order as a series of memo text fields as separate records. These are normally completed via a...

Thanks for the reply. I get the gist of it and the solution could be of value to me, but I cannot get it to work. If the field is blank (null), then the first tab works but thereafter no tabs are created. If the field has something in it to start with then again no tabs are produced. I have...

Is there any facility to use a "tab" when entering narrative in a "memo" data type field in a form? Any help would be appreciated.

Have now investigated the DLookUp() function and found it worked very effectively once I realised you could have more than one condition clause.

Thanks to everyone for all for the pointers. I have now achieved the result I needed, (possibly not in the most effective manner). I have created a subroutine in the OnOpen event of the form, and using the ListCount, ColumnCount and column properties to interrogate the the Look Up table of...

Thanks for the replies. However, this approach does not work here. The data held in the form control source is the numeric key (AutoNumber) to the records held on the table of possible values. Therefore I can set the default to the appropriate key i.e. 27 and the user is presented with the value...

Can anyone please help me with the following problem? I wish to set the default value of a Combo Box on a form, whose source is a table. An example is Order Status code that can have the values Outstanding; In Progress; Completed etc. On a new order I wish the Order Status to default to...

Can anyone please help me with the following problem? I wish to set the default value of a Combo Box on a form, whose source is a table. An example is "Order Status Code", that can have the values Outstanding; In Progress; Completed etc. On a new order I wish the Order Status to default to...