Recent content by Jester1147

disregard the first part... i have the text box resolved. But not the Expression. It still shows the RankID in the expression.

I apologize for my ignorance, but that code will go... where? Also will that fix the Expr issue as well?

kind of have two problems here. One: Creating an expression to compine fields into one Expr1: [Rank] & ' ' & [First Name] & ' ' & [Last Name] - Im sure this is pretty self explanitory. My issue is that [Rank] is from a combo box so it will only display the "RankID" which is the autonumber...

actually the subform is linked by the Deployer's name and not the serial number... which is why the Table M4 has two entries, two serial numbers, one name. The part that has the M4 listed is the nomenclature. Eventually, there will be 4 different weapon systems loaded up. The M4 Table is the...

"Multigun Subform1" sits in all of the "AF1297" forms in the same spot. The form has been stripped down to just the two fields to maintain the structure and stability of the form.

its something similar, but the form is to not be editable here is a stripped copy of the db (obviously, the personal infomration needed to be removed)

the scopes are tracked serially, however that is it (FYI, i have a mobility/contingency weapons account for maintenance personnel, so no extra gear would be serially issued). I was able to get the subform in to display properly except for one factor, When the subform itself is pulled up, the...

Thanks for the info... i will give it a try. You mentioned about if i could guarantee that no more than 2 would be assigned, yes. The database is for weapons issue and the personnel would never be given more than 2 weapons (pistol/rifle) except for extreme circumstances (of which would have...

First, i want to say thanks for the help i have received so far... its been quite positive. However, i think that due to the circumstances of the type of db i have been asked to construct, i may have found myself backed into a corner. Instead of using dummy terms, i will use the actual names...

I think im doing something wrong here... i just cant figure out where. I have two tables in one query. the common field is "Deployer's Name" which is in one table with two other fields in the query. In the other table is the list of equipment they would be issued. now for the equipment table...

So here is my question... Using a form_load and if/then for enabling/disabling some fields depending on if a particular checkbox is checked... is there a way to have this process reset after a new record loads? Currently if checkbox A is selected, fields 1,2,3 and 4 can be filed (using the...

Hey Coyote... its not that i want to open the same record the next time the form is opened... i want to open the current record on one form... in another seperate form. missinglinq... the "code" used is the macro set up by the wizard. As i stated... i dont quite know what all information you...

OK... now im fairly new to Access (know enough to cause some trouble... basic BASIC stuff... etc) but i know squat about VB. I know that most stuff can be accomplished by wizards as well. My issue Creating a program to track items issued (in this case, keys for a building). There are...