Search results for query: *

The button solution worked. Thank you very much.

When you create the button, I'm assuming the label goes into the name field. If this is correct, do I put the name in quotes as you have listed or is it just the text? I've attempted to use the code, but haven't had luck with it.

We have created a form with a subform in our database. The subform is related to the mainform via a TransactionID. The subform is a continuous form used to enter products being bought by a customer. When we first enter the form we have focus set to the first field in the subform because this...

Sorry that it's been awhile since I've replied. I just assumed the problem was solved. Actually the problem was solved our way with code, but I read your last post and noticed the part about the link child/master fields and decided to check them out. It turns out that those were blank for our...

Alright. There's no need to answer the last post. We found a way around the problem with a kluge solution. We ended up storing the value of the TransactionID of the Transaction form in a variable and then just put this value into the TransactionID of the OrderLine subform. I'm still confused...

I received your email and opened the sample database. It seems to do what we want, but the problem with our database is that the TransactionID in the subform is not matching up with the TransactionID in the main form. I see that you don't have the TransactionID field in the subform, but...

I'm not exactly sure what version we're using in our lab. I know the version I have here is 2003 so that won't help. More than likely that version is 2003 as well. You can send me the file though if you would like, and I can attempt to try it. My e-mail is son_seph14 AT hotmail.com

You say that the main record is saved when you enter the subform the main record is saved. What does this mean. That the record within your tblTransaction is saved?? If that's what you're saying then I don't think that is happening with our database. As I said in my previous post, we added...

I've checked out the Enforce Referential Integrity in the Relationship diagram. Just to test this out, I unchecked the box on the relationship between the Transaction table and OrderLine table. Once this was removed the database worked correctly. Obviously the problem is now that there is no...

I swear that as soon as one problem is solved, another comes up instantly. We've now got the forms showing up correctly, and the subform is now opening in add mode. Everything looks good, so that's a plus. The problem we're having now is the actual data entry. The main form is called...

We finally got the forms to show up using the subform that you had suggested. The problem we have now those is that the form isn't opening in add mode and we wish to do that. When we open the Transaction form which has our products subform in it, it shows all the current records that would...

There is no record to show. We want to be able to type in product information such as the size being bought, color, etc. And yes, we want the form to be a continous form so that after one product is entered you can enter another during the transaction. Will the fields not show up if there is...

I've attempted what you said, but the fields still are showing up. The exact thing I'm doing is creating a query/form using the wizard. I'm then taking all the fields from our transaction table and product table. When the form is created, everything will show up in the header, but when the...

I think that's what we need to do. The labels and text boxes themselves aren't showing up. That's the problem. I'll attempt the query way being that it seems like the easier fix. If not then I guess I will be back. Thank you for the information. It's vastly appreciated.

Here is what is going on. We're creating a transaction database system to store product information from transaction at a local business. On the one form we're creating, we want to be able to show the transaction information on the form which includes the transaction id, and other information...

We created a database and attempted to show a number of different text boxes from several different tables in the details section of a form. Everything appears correctly in design view, but when we got to view the form, nothing appears in the detail section of the form. We've been attempting...