Search results

Is there an easy way to refer to fields from multiple tables without creating subforms, or using queries?

I came up with a solution. Its much more complicated then setting the controls default, but it works. I simply linked the control to a table with one field in it. So whatever value is entered is stored in the table permently. It works

yes I think that is what I'm looking for. Thats a good idea, but I tried it and it doesn't keep the value. I close the database then reopen it and it puts "#Error" in the control. Just to clarify: I'm working with only a single control. If the user pushes a button, whatever value is in that...

Well, this particular value can change. Depending on the users preferece. So the defualt value can't be hard coded so to speak and I would like to make the changing of the defualt value user friendly.

I tried setting the defualt value of a control threw a macro but it doesn't work. Well it works...but as soon as I exit the form the defualt value that I set erases. SetValue= Item=[Forms]![Main Form]![Danger?].[DefaultValue] Expresion=[Forms]![Main Form]![Danger?]

Thanks a lot! I got it working now.

Dude! Conditional formatting is the magic word. I know how to do what I want now. Thanks mike

I want to run a macro that uses a gotorecord command. In the gotorecord command it asks for the form that you want to change records in. But it only displays the Main Form and not my sub form. I could open up the sub form seperately but that would make things much more complicated. Is there a...

Well I had an idea...but it didn't work. I'm trying to hightlight only certain records in a continuous form. I've been looking online and evidently its a pretty hard thing to do.

how can you set the foreground color property thru just an expression? I'm trying to set the color of a control in a form. I can do it through a macro but for some reason I can't thru the control's events or data source. Thanks

Well right now I'm accessing values from my table through one of my main forms. It would be convenient if I could just refer to those values directly and not go through a form.

Is there any way for a macro to access data on a table without going through a form?

I'm getting a write conflict in my data base when a certain macro is ran from a text box in one of my forms. I put the database in exculsve mode and it still happens. All the macro does is open another form then immediately close it. The write conflict happens right when the macro reaches the...