Search results

No it's a single record form. Only 1 record displays at a time.

Aha, being down under that 'US' spelling catches me all the time. No error now but code not working i.e. nothing is happening..

Thanks for your reply Arnel. I get the following error:-

Hi all. I have a bunch of yes/no fields on a form and I would like to set the background colour of the associated label when the field value is true. The code i've tried on the first label isn't working properly in that it is setting the background colour for every record not just the record...

Thankyou for this post Uncle Gizmo. Couldn't figure out why I was having the same issue.

Can't you just use a 'Combo Box' wizard? Much easier and no VBA required.

Many thanks Pat.

As an extra point of note, the end user wants to be able to see current 'Floor Stock', 'Base Stock' and 'Backorder' information (all of which is calculated in the background) for all stock items in the continuous form of which there are over 2500 which is why I've gone down this path. Couldn't...

It's actually for an individual user (only 1 staff member), but I acknowledge your point. The idea is that as multiple items are ordered on each order, once the 'Add To Order' box is ticked and all items have been selected, the user then clicks the 'Save Order' button which does everything ni...

yes it is.

It's being used as part of a Inventory and Ordering System and I want to reset this yes/no box on each record every time I open this [New Order] form so the user then clicks the yes/no box for each item they wish to order.

Hi guys. I have a yes/no (checkbox) I want to set to 'No' each time the form loads. I've tried {me.fieldname = No} in the OnLoad event. This only works for the first record on teh form. Anyone know how I can apply this to every record on the form? VBA beginner here.. thankyou in advance...

Thanks So Much Arnel!! Syntax sensitivities always bring me undone. Thankyou to everyone for your assistance. Gigitty

So now it's having an issue with the Index I created on that field. Ok to remove the Index??

Thanks for your prompt reply Arnel. Placed the code in but absolutely nothing happens when trying to trigger the code..

Thanks guys!! that fixed the error. Now if I want to take the user to the record that already exists as part of this process?

Got one step closer, then got this one.. Should there be something in here that then takes you to the record that already exists??

This is the error message..

Hi Gasman. Yes UMRN is a text field. Which part of the text do I need to place the single quotes around??

Hi guys. Trying to achieve the same result based purely on the UMRN field but keep screwing up my syntax. I'm a VBA novice..