Recent content by reezebeez

Hi, I thought I was being clear. They are headings on a form. They need to be editable. I don't work till next monday, so I can't attach at the moment, but on Monday I can attach it for you to show you if I am not being clear enough/using the right terminology.

hmm, ok, they are labels or headings for a table i've created, and they need to be editable but not recorded on any table or anything.

Hi, I have a form with some vertical unbound text boxes, they are table headings for my data, but they need to be editable. I can enter data in them perfectly but once you close the form the data is lost. I would like the data to be saved on the form. I have tried turning them to labels but...

woo hoo, if statement works too!

Oh my Gosh! you are a freaking Access genius! :D it works! so now to get the if statement in there and I'm all ready for the next question, can I get an unbound text box to save its entered text? (or should I post a new question?)

Hi, only new to access here, however I was having this problem too. I found that is occurred mainly when I had the table open and the form (making changes on the form), so now I make sure I have only the one form open that I'm working on and ... so far so good. Hope this helps.

I assume you mean the field ID - it is an autonumber field. and the data entry property of the form being opened? so scrolling down the list i see one called 'data entry' its set to yes.

I have tried everything to no avail. i am going round and round in circles. this is what i have tried: Macro: If [term 1 allow]>0 then openform form name permissible explanation view form filter name current record where condition = [id]=[forms]![permissible...

Thanks, you have me searching for the right terms now. I don't know what controlname is about though, still trying to work it out, have been dreaming about what the answer it!

Hi again, so I've had a crack at it and I can get the window to automatically pop up - but How do I make it pick up the current record I was editing? I need to know if this is possible or I thought of another way - I could place a hidden field that appears for input each time the Permissable...

Hi and wecome!

Hi Jaggas and Welcome. I agree entirely with your comments, I'm only new to Access but have been working with other db programs for 20 years! I've never felt like such a newb! Best of luck.

Hi Ray, and welcome.

Welcome, I'm a newbie too.

Hi, hope this is the right place to post this question. So I have a database (I've attached it for you). I'd like to set it up so that in the "incentive scheme" form when the field [term 1 allow] is changed and is more than 0 then have the form "permissible explanation" appear with that record...