GoToRecord stopped working during Form_Load()

Its hard to tell what you did differently without seeing exactly what you did,

But you are heading down the worng path with your table structure, Your table strucutre should look more like this:

tblGrants

GrantID (Primary Key Autonumber)

GrantName

GrantDueDate

GrantScope (text: either I or E

GrantTypeID (Foreign Key to Research Type lookup table)

SponsorID (FK to Sponsor table)

SubSponsorID (FK)

SponsorGrantID

GrantMax

GrantDR

GrantMaxYears

GrantReqYears

GrantTotal

DateSubmitted

Notes

CollegeID (FK to table of colleges)

You would then need a table of Sponsors, Colleges and ResearchTypes (Research, CSA, etc.)

You should have 2 tables for PIs

tblPI

PIID (PK Autonumber)

Firstname

LastName

other info about PI

tblPIAssigned

PIAssignedID (PK Autonumber)

GrantID (FK)

PIID (FK)

Primary (Yes/No)

Indirect funding and Awards should be in separate tables

Thanks so much man.

So the table I made has 20-30ish entries:

I retried the combo box thing from the wizard and now it's properly changing everything. It wasn't before. I have no idea why; I just deleted the form and made a new one and it worked. From what I can tell, it's b/c Access hates me XD.

So now the update form looks like this and is working (fingers crossed - this is where I was before I even went online for help like 3-4 hours ago #fml):

I have absolutely positively no idea why it works now but didn't before. Like none. Zero. I'm so confused.

I'm going to add all of the fields that aren't up there to this form, then make a second form EXACTLY like this one except when it loads, I'm going to tell it to make a new record when it opens. My plan was to do that with DoCmd.GoToRecord , , acNewRec in form load. If that works, I'm done for today b/c I slotted this to take 1 hr (when I did it last time it took 30 minutes!) and it's turned into an all day project. I'll get back to it either today or tomorrow morning, and when I do I'll update you on whether or not it blew up.

So other issues. You said; "Make a table with the pertinent data"

This raises red flags right off the bat. No way a database as you describe should be one table. Just on what you have posted you need a Grants table, a colleges table, an investigators table, a sponsors table and probably more. You probably should read upo on Noirmalization before going further. Befire yiou start designing forms yiou NEED to get your table strucutre squared away.

Users should NOT directly access tables, You should use forms for all interaction between users and tables,

When creating forms, I almost always use the Form wizard, rather than dragging and dropping fields onto the form. This makes it easier to properly design the form, thgen customize it to your needs.

No, you misunderstood me. Ken and I are not saying to not use the Record number to filter records, but you select that record number from a combobox.

If you create a combobox with the following properties you can use it to select the RecrodID:

RowSource: SELECT SIROID, Professor, DueDate FROM table ORDER BY Professor, DueDate;

Bound column: 1

Column Count: 3

Column Widths: 0";2";1"

This will display the professor and due date but when selected, will return the SIROID.

Another plce you misundertood Is with the Expr1000, this means the feild appears twoce in the recordSOURCE, not thge recordSET. The Recordsource ius where the form piulls the set of records from. If you can post the Recordsource as I asked we can point out the error.

Finally you don't have fields on a form, you have controls that may or may not be bound to a field in a table. Each control has a Name property that is how you refenrece the control in code. And no, that code does not go in the Form Load event. It would go in the After update event of the combobox.