Charactersand Values on different forms

[chris11590]

Can anyone please break down the characters for coding. for example, parenthesises () are used for field names. What do the other charachters, [],", and so on.

i would like to learn about writing expressions, events, and procedures.

also,i have a row of combo boxes which are linked to one control source from one table (same value from same field). when i created the row of combox boxes the list of records appear individually on seperate form. so one record on form #1 , second record on form #2, and so on.

what i would like to accomplish is a row of combo boxes. first combo box, i can select record one, 2nd combo box i can select record two, and so one...
one way i say was a list box to list the different categories and subform, but now sure how it was created, something like that.

help. cant move forward stuck for weeks.

 

[wazz]

Can anyone please break down the characters for coding. for example, parenthesises () are used for field names. What do the other charachters, [],", and so on.

this is usually the other way around. () for entering values, [] for field names.

if you look at what you wrote you can get an idea. you wrote: "...i have a row of combo boxes which are linked to one control source from one table (same value from same field)...". you see how you entered some extra info in the ()? same idea. if you have a function, say DLookup(), you have to enter more info in the (). (some functions do not require more info!).

if your field name is 'My Field Name' you need [My Field Name] because of the spaces: with spaces and without [], where does the field name end?? without spaces in the field name you can just type, MyFieldName and it's clear where the name starts and ends, to both anyone reading the code and the interpreter.

more characters will become clear as you go along.

what i would like to accomplish is a row of combo boxes. first combo box, i can select record one, 2nd combo box i can select record two, and so one...

search the forum for 'cascading comboboxes'. that should get you going. there are samples in the sample database forum and/or code repository. pat hartman also has an explanation of using '!' or '.' which will help with coding. search search search the forum. if you're not sure what to look for, then ask away.

 

[chris11590]

thanks !!!i think i understand. so fustrated working on project for my boss and times seems to be going by quickly ,and i feel as if im not accomplishing what i like to accomplish. simply stuck because of these combo boxes. wow, i have a lot to learn.

chrissy.