Recent content by access_uk

Thanks but it's still not working. I think it has to do with my subform names. I will keep trying. Thanks for your help

Hi John Thank you for the quick reply. I got it to work but I forgot to mention that this is a subform within a tab control. How do I reference this subform in the On Current Event of the main form? Do I have to use something like this? Forms!Form1.Combobox1.requery? Thanks

Hi all I would appreciate any guidance on this problem as I have been struggling with this for the past 2 hours. I have a combo box in a subform that is populated by retrieving records from a table using a SELECT statement. I want to restrict these records based on a value from a text box...

Thanks, but this is for an assignment and I have to open the Tables from the Switchboard. If I build my own Switchboard, how can I make the new Switchboard open in the Main Switchboard rather than as a separate form? Many Thanks

Hello Hope you are all well. I would appreciate any help to resolve this issue: I am having problems with my Switchboard in Access 2003 where when I click the button to open a Table from the Switchboard, the "Go Back To Main Switchboard" button stops working. My Main Switchboard contains...

Fantastic. It works when I put the code in Form_Current() Thanks all for the tips. :)

I know programming and how the IF statement works. I just don't know to set up this in Access so I can view the message when the field value is over something. Thanks for your help

Ok, I got it. But how about the message being displayed right next to the Price field when the Price field value is over 1000? How do I do that?

Thanks, but I actually want to display a message next to the Price field when it is greater than 1000. When is less than 1000, then no message is displayed. So it would look like this: Price: 1000 Price: 1250 - price is too high The conditional formatting only allows me to change the...

Sounds great, but how do I do that? Sorry, I am fairly new to Access. I am using Access 2007. Many Thanks for your help.

Hi I have a form where there is a field called Price. I need to display a message "Price is too high" next to this field only when the Price field is over $1500. How to do that? Any help is greatly appreciated. Thanks