Search results

yeah like i said before i got lost in all the "i wants" and the "i needs" for the database that are in my head so your words of guidence really help me!

ok thanks for the words of encouragement i was getting a bit frustrated. I wasn't sure if i was clearly explaining what i wanted, which i had seen done in sample databases I expected a ton of work which i am hopeful will be well worth it when i get it done

I just wanted to autopop the customers name for verification purposes it dosen't get stored or anything just a security measure to make sure the order is beign created to the right customer

so can I use more than one subform in a form? since I apprently have to use the subform to autopop the customer info and to create the order

yes it is, What I keep running into is a message saying "Control Can't be edited, it's bound to AutoNumber field "CustomerID" but If make it Unbound i can select from the dropdown but nothing populates. Also If i use the record navigation on the bottom everything changes now I got this to work...

I'm having a hard time getting the customer's information to autopopulate by selecting their CustomerID from a dropdown....

ok after I sat staring are it for a while that was what I thought but I wasn't sure. So now the first thing I have to do is to make a record in tblOrderHeader right? so that I have something to link the customer to the orderdetails with right?

ok i'm working on the form to create orders And i'm stuck. the wizard is asking for a field that will link the main form to the subform :confused:

Sweet you rock!!!!!!

ok i'm still having problems, I trying to use this in a form. I have tblStates fields in order are: StateID (PK)-autonumber ShortState-text(abbreviations) State-text(entire state name) my form is setup as follows: Control Source : BillingState Row Source: tblStates Row Source type...

Nevermind, I made it so the Multiple Item form closes when an button is clicked then reopens after the user has updated or deleted a record. I like this better because I don't like having a ton of thing open at the same time.

isn't there a way do do within the commands for the button that do the adding, deleleting and updating?

well hat i'm running into is in my muliple items forms the changes are not showing unless i manually refresh or close and reopen

sorry I didn't realize there was more than one. I want to refresh after I Add, Delete, Or Edit a record but in the button command I don't know VB (i'm not ready for that yet LOL :eek:)so I would like to avoid it for now

Me again?:confused::rolleyes::D

all righty got it thanks

but they are ok to use in forms?

How do I get Access to refresh automatically after a command is exicuted?

so those are the ones to avoid?

ok i'll attach what i have when i get done with this part i'm working on