User Profile

likemike973 · Mar 1 '08, 06:10 PM

I tried the first option. It works great! I will have to rebuild the form, but that is part of the learning curve.

Thanks for all the help,
Mike

likemike973 · Mar 1 '08, 05:50 PM

I'll give it a try.

Thanks again
Mike

likemike973 · Mar 1 '08, 02:53 AM

I checked out the small green block, and yes you are correct, like you stated before I am using the wrong source. My form is putting information into a table, tbl1 and I need one piece of calculated information from a query, qryprofit, to go back to the form to display a calculated value. Is there a way to get the one piece of information from the query back onto the form while maintaining the integrity of the form based on tbl1?

...

likemike973 · Mar 1 '08, 01:19 AM

Thanks for the help so far. I have attempted a few things on my own. The information is coming from the Record Source, but like you stated it hasn't calculated the fields yet. Is there a way to make it calculate, by refreshing? or maybe using another query to calculate.

Thanks for the help so far.

Mike

likemike973 · Feb 23 '08, 08:05 PM

OK now I understand bound and unbound, I have actually been doing it just did not know the term. Thanks.

I created a Text Box and tied it to a control. In this case =(qrynetprofit![Net Profit]), and when I go to the form view it show #NAME? error in the field where the Net Profit value should be. Have you seen this before?

Thanks
Mike

likemike973 · Feb 23 '08, 12:30 AM

Forgive me for being a newb, how do you bind? I tried searching online and vb stuff is beyond me. Is there a way thru expression builder or the properties to do it?

Thanks Again,
Mike

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

MS access form issue