Search results

I have a table with some combo selections with row source No;Yes, bound column 1, column count 1, and default value "No", limit to list set to yes, required = yes, allow zero length = no. When I create a new record though, all of the combos show 0, and I have to select No or Yes manually. The...

Thanks - yes that fixed it. I did a test though - with a new form and tabbook, and with cycle set to do the records - and the behaviour in the form I'm working on isn't normal. It should change the record leaving the tabbook, not when entering it. It doesn't matter now though. Thanks again...

That won't work I'm afraid - it has to be deployed. Also, I checked, and its already set to field, not record. This has never happened before. I don't know what could be causing it. Aidan

I have a tabbook on a bound form, and an unbound combobox just before the tabbook. Whenever I tab or enter out of the combobox the form goes to the next record. Is this supposed to happen? If so, how do I stop it. Many thanks in advance, Aidan

Hi, Sorry, I was just trying to find how to pull the thread - it started working after I closed and reopened the form. Is this possible on this forum? The problem was that I was changing from an unbound parent form to a bound one. From setting the the linking control's value, to letting this...

Sorry, but I'm not using a query like that. The form is bound, but the control I'm searching for the primary key isn't. Might there be another reason for this error? Aidan

I'm sorry, I didn't explain very clearly. Parent contains SubA, and SubA contains SubSub01 and SubSub02. SubSub01 and SubSub02 need are foreign key related to Parent, not SubA. SubA is only necessary because of the use in 2 forms. I can just use me.parent.parent for VBA, but what about linking...

Up until now I've put a tabbook on my main forms and subforms on each page of a tabbook when I want to display various tabledata related to the main form. Now though I want to put the tabbook on a subform, so that I can include it from two different parent forms, but I thought perhaps I should...

I found this thread http://www.access-programmers.co.uk/forums/showthread.php?t=14562&highlight=absoluteposition but I get runtime error 2105, you can't go to the specified record. I checked with a messagebox and the value isn't null or out of bounds. Aidan

How do I find a record number from arbitrary criteria so that I can use gotoRecord? I just can't find which function. Thanks in advance, Aidan

Thanks, it works how you would expect now - the return key works every time, and I didn't know AfterUpdate was what I needed to use... I was however trying to have the function run every time the selection in the list changed - not after pressing return - so that the user could have instant...

I have a combobox which needs to call a function f(combobox.value) during its onChange event. Currently though, combobox.value appears not to change before the onChange event, and so the function receives the wrong (last) value. Note - the actual text in the text field of the combobox *has*...

I think you're right about the composite key. I'm not sure why my boss wanted that honestly. However the referential integrity thing you mentioned wouldn't work - he wanted to be able to delete the parent table, leaving the child accounts in limbo, but I just received a reply from him and he's...

Basically I have a table Customers and a table Accounts. #customer is the sole primary key of Customers, and #account+#customer is the composite key of Accounts. A customer cannot create a new account without being a customer, and so normally I would enforce referential integrity and in access...